Forum Discussion
Search box formular issue
Good morning guys, I have created a "Search Box" in my excel worksheet by coping a video of "How to add a search box in Excel" but I must have something wrong in the formular as it's not searching th...
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 mate here is a link to my work sheet. There's no real sensitive information so have a look at it and let me know how to fix it. 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.
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.