Loading userform mid routine

Hi there,

Just have the desired sheet to be opened attached to each button, ie for Sheet1 assign this to the relevant button:

Please Login or Register  to view this content.

HTH

Robert

how do I get from the macro running to loading the form

The following will open a user form called UserForm1:

Please Login or Register  to view this content.

just change the user form name to what your form is called and put the line of code wherever you want the form to open.

knowing which button has been pressed

You said you separate buttons so just assign the code to open the relevant sheet for that button You can always get a list of the visible sheets (which you then can select by clicking one) in a workbook by right-clicking the tab navigation buttons in the bottom left-hand corner of any workbook.

You could put this in the Userform's code module

Please Login or Register  to view this content.

OH, the buttons are on the user form.
Then each button will have its own Click event and you code the sheet in the appropriate Click event.

Please Login or Register  to view this content.