I have developed a userform in Excel 2000 using VB6.2, for entering data of
quotes and orders into seperate spreadsheets. When a quote becomes an order,
I would like to retrieve the data of that quote from the quote spreadsheet
back into the userform, add more information to it, then send it to the
orders spreadsheet.

My question is - Is it possible to enter a key word in the userform and
maybe have a FIND button to bring up the rest of the data? Normally, the
Find command would simply go to the data in the spreadsheet but I want to
keep the user out of the spreadsheet.

I don't know if you can call up any of the text boxes in a userform VB
language to send data to it. Is this possible?

Thanks in advance!