Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help updating userforms
I have a spreadsheet called "FindPurchase" where the user inputs the
ref of a product and it starts a macro called FindPurchases that gets 1) all the references (brand and type) and 2) all the purchases of that product (information in 8 columns and no more than 5 lines). We need to use this information quite often in other spreadsheets. So we want to create a macro that when a button is pressed a user form is open. This userform has a textbox called "REF" where the user enters the reference, we then want to fill in the descriptive fields (brand and type) and the purchases information (we were thinking of a list box). I think the best option is for the macro to silently run the findpurchase macro and update the FindPurchaseSpread Sheet, but I am stuck in the updating of the user form with the info from the spreadsheet. Thanks in advance. PA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel losing focus and non-updating userforms | Excel Programming | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions | |||
Updating Cells w/ Userforms | Excel Programming | |||
Updating entries on a spreadsheet via Userforms | Excel Programming |