ok thanks ill try that.

one thing im having trouble with is when recording a macro, it refuse
to record the selecting of my textbox, the pasting of the text into th
textbox, or the clicking of the command button.

getting the text into the text box should be easy enough with the cod
above, i can just say textbox2.text = mtext, but i also need it t
press the command button which performs a search based on whats in tha
text box, for some reason the macro wont pick this up so im not sure o
the code for it

--
Message posted from http://www.ExcelForum.com