G'day Excel Forum
I’ve been following a method I found on the net for building a search bar with suggestions dropdown (like a Google search), described here; http://trumpexcel.com/tag/excel-search/
It’s worked quite well however I am having a small issue with it;
Weirdly whenever I click on any button, tick any checkbox or hit enter after typing anything elsewhere in my sheet, the search suggestions box I’ve built using this method drops down for no apparent reason (see attachment).
Has anyone any idea why it might be doing this? Could it perhaps be clashing with another code or have something to do with the version of excel I'm using (2010)?
Would appreciate any insight you'd have
Regards
MattRNR
P.S. I've hidden the helper columns in the 'Entry Number' column, in the complete version of the spreadsheet these will be hidden by formatting.
Bookmarks