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 the rows or column I need it to. My problem is, I can't seem to even bring up the formular to be able to fix it. Where do I go to locate the formular so I can repair it?
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?
- Warren1959Copper Contributor
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.