PDA

View Full Version : text box search



photon_ed
06-02-2006, 05:02 AM
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
06-02-2006, 05:08 AM
Is the textbox on a form?

photon_ed
06-02-2006, 06:00 AM
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
06-02-2006, 06:04 AM
Take a look at John's KB entry
http://vbaexpress.com/kb/getarticle.php?kb_id=821

photon_ed
06-02-2006, 06:22 AM
Thank you, I will play around with it.

yours,
Ed

photon_ed
06-02-2006, 07:39 AM
It works perfectly! thank you lucas :)

yours,
Ed

lucas
06-02-2006, 12:09 PM
You're very welcome Ed
Please mark your thread solved if you can. Some people are having trouble with it since the forum upgrade.