Dynamic Search?!

Hey I’m new around here and I would like to know if it is possible to make a dynamic search in Excel, say I have Textbox and I need that every time I type a new letter in it, Textbox.Value turns to be the new search parameter. In other words if I type C in the textbox the search result should be all words in the specified range starting with C. I’ve tried with Excel Worksheet functions like Find and FindV, but those are only useful with exact coincidences between the textbox value and the range I’m searching in. Any help is really appreciated thx a lot

Hello memosky,

You should use a ComboBox control instead of a TextBox. The ComboBox has the search function already built-in, and accepts input like the TextBox.

Sincerely,
Leith Ross