Forum Discussion
Search box formular issue
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar https://1drv.ms/x/s!AlrZrNBpiycehpl9zrwTqkToWyXPqQ?e=D3wpRg What I was trying to do was, search for a type of part I've fitting during the rebuild whith out having to scroll through the whole work sheet, for example, the name of a supplier or an actual part. I must have selected too many rows or something. Anyway, just being able to find the formular would be a good start.
https://1drv.ms/x/s!AlrZrNBpiycehpl9zrwTqkToWyXPqQ?e=D3wpRg
See the attached version. It is now a macro-enabled workbook (*.xlsm). You'll have to allow macros when you open it.
To view the code, right-click the sheet tab and select 'View Code' from the context menu.
Enabling Marco stop the excel sheet from saving in Onedrive.
I've had to disable Macro in all my spreadsheets to be able to "Auto Save" in Onedrive. I use Onedrive for all my files. I've had to go back to a previous version of this spreadsheet because even though I have gone into settings and disabled Marco it still won't Auto Save. This stuff is very frustrating as I don't understand the process fully, very complicated.....
Here is a version that doesn't use VBA. The search box and filtered range are now on another sheet.
It won't work in the online version of Excel since ActiveX controls do not work there.