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