Insert a search function in Excel

[Stroppy]

Hello Excel experts,

I have a simple workbook of about 8 sheets. It's a catalogue of brochures with each of the sheets allocated to a category. I'm making a simple "front page" entry point with 8 coloured hyperlinked boxes to each sheet as much for aesthetics as ease of use. Sometimes the users may want to search the workbook and whilst it's easy enough to do a "find...search within workbook" I'd like to make it nice and simple. Is it possible to make a search box on the front page? I imagine it would be inserted into a cell with an inactive label beside it saying "Search for a brochure here" with a box where they can type a word - like a google search box. The search to be activiated by simply pushing "enter" or I make a "Go" cell...any suggestions? I'm not great at Excel so go easy with the instructions please!

Thanks

M

 

[xlbo]

Not without VBA

If you want to persue a VBA solution, please post in the VBA forum: Forum707

Otherwise, I find Ctrl+F does the trick ;-)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question