Change event as you type in textbox

[antros48]

Hi all,
I am making a search box in excel using macros. I defined a cell for entering the search word and a command button which once clicked will color the row where the search word is located. I read that using the change event of a text box, this can be modified in order to be able, as you type in the textbox, to have a coloring of the matching rows in real time.
I don't actually know how to incorporate that to my original code and replace the command button object with a textbox.
Any help appreciated.
Thank you

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Akuini]

Try this:
Put the code in the code module of the sheet where the textbox is located.

Please Login or Register  to view this content.

[antros48]

This worked perfect. I really didn't know whether the change function would produce real time change unless maybe an enter button was pressed. Thank you very much really appreciate your help

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Akuini]

You're welcome, glad to help, & thanks for the feedback.