Macro to open search box?
 

I have a spreadsheet with 2 tabs - one containing all the data, and another
that acts as a front end.

I have added several drop downs, and created macros that apply autofilters
to the data tab based on the selections.

I did want to add a keyword search box - is it possible either to create a
simple macro that summons the search box (ctrl - F) and pre-fills with the
keyword entered into a cell, or more spectacularly to then only summon the
whole records of anything containing that keyword?

All of my 'records' are on a row each on the data tab, so if there was a
match it woul just bring through the whole row for any containing the keyword?


Thanks for the help.


Paul

Macro to open search box?
 

You can use OnKey to map keystrokes to macros

You can have our macro make the combobox/dropdown visible and populate it
with a value in a cell. You can associate a macro with it "click" event to
search your data and populate the interface sheet with data from the data
sheet.

--
regards,
Tom Ogilvy


"PSutherby" wrote:

I have a spreadsheet with 2 tabs - one containing all the data, and another
that acts as a front end.

I have added several drop downs, and created macros that apply autofilters
to the data tab based on the selections.

I did want to add a keyword search box - is it possible either to create a
simple macro that summons the search box (ctrl - F) and pre-fills with the
keyword entered into a cell, or more spectacularly to then only summon the
whole records of anything containing that keyword?

All of my 'records' are on a row each on the data tab, so if there was a
match it woul just bring through the whole row for any containing the keyword?


Thanks for the help.


Paul