Button Clicked

I have a spreadsheet and on that spreadsheet there are various buttons that cause various subroutines to launch. Some of these buttons cause a user form to be launched to gather additional information needed within the subrountines.

I am to the point where I have two buttons which both need to open a particular user form, but once the user form information has been gathered different subrountines need to run based on which button was pushed.

Is there a way to capture which button was pushed?

Thanks

Jeff

Hello Boylejob,

If the buttons were created using the Forms controls then yes you can.

The code to use is...

Btn = Application.Caller

The Variable Btn will contain the name of the button or control that was selected by the user on the worksheet.

Sincerely,
Leith Ross

Thanks Leith! I know it had to be something simple, but I just was not able to find it.

Jeff