text box search

[photon_ed]

Hello,

Can someone tell me the codes to search and highlight data from a spreadsheet, using infomations from a textbox input.

I will be grateful if someone can give me an example.

THank you.

yours,
Ed

[lucas]

Is the textbox on a form?

[photon_ed]

either i guess, or on the spredsheet, which ever is easier for you. I can play around with it afterwards.
Thanks Lucas

yours,
Ed

[lucas]

Take a look at John's KB entry
http://vbaexpress.com/kb/getarticle.php?kb_id=821

[photon_ed]

Thank you, I will play around with it.

yours,
Ed

[photon_ed]

It works perfectly! thank you lucas :)

yours,
Ed

[lucas]

You're very welcome Ed
Please mark your thread solved if you can. Some people are having trouble with it since the forum upgrade.