Search box formular issue

Copper Contributor

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?

5 Replies


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?

@Hans Vogelaar mate here is a link to my work sheet. There's no real sensitive information so have a look at it and... 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. 

Warren Taylor Worksheet 


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.

@Hans Vogelaar 

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.