Open another workbook for multiple userform event use.

Hello folks.

The use of this userform is to find a customer reference number. Im using two combobox's and a textbox.value that are populated from another workbook.

Though the way it is at the moment it opens the workbook and closes the workbook every time a new value is set to one of the combobox's.

I want to open the workbook on the useform initialize and do everthink the useform need from it. And then on the userform terminate close the workbook. Or somehink to this equlivent so this process of finding the customer referance number goes faster.

Im just a little unsure of the dimmension of the variables for each event. For the source workbook.

Please Login or Register  to view this content.

Thankyou.
If you would like the thread title changes, let me know what to and ill do it straight away.

Hi D_Rennie

could you open the workbook in "Initalise" Form option and close the workbook
in "Deactivate"

Please Login or Register  to view this content.

Go the Titans

So then with setting the variables somethink like

Please Login or Register  to view this content.

also can i set this variable on the Initialize and referance to it within the various events "click,change,ect"
Pike, have you see the casino this week its all dressed up for the titans match.

Hey D_Rennie
you can declare the demention x as Public in the form just below opiton explicit

Please Login or Register  to view this content.

then use it in your other subs
but call x something like sWorkingBook
S for string and then a unique word to limit any errors/conflict

off to the footie

Broncos are in trouble

catcha

If you switch off screen updating then you only need open the workbook once, do all the actions then close it

the other option is when the comboboxs are clicked they run a combined sub
that checks to see if file opens
case statements of each combobox
then on close userform if open close file

broncos to good