Would like to retrieve data from spreadsheet to userform

B

Bucko

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add additional information to excel form after original data entry 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Odd behaviour with a userform 0
Linking data in MS Word into Excel 5
Creating a Chart on form from selected data in query. 0
Using Access Database to build contracts with fields on pdf document 0
Populate userform spreadsheet 1
how do I link a constant or variable to form 4

Top