Assign macro to button on a multi-page tabClosed

Question

Hello,
This seems easy but I am really stuck. I need to have a floating set of commands in a spreadsheet and I can't use attached custom toolbars (IT policy).  I created a userform with a multi-page tab area, each tab has a number of buttons on it. I want to assign a macro to each of the buttons but I can't figure out how.  I already created the macros. Can anyone help me?

thanks
Shelly

Nayana Adassuriya · Answer

https://www.ozgrid.com/Excel/assign-macros.htm

This may helpful to you!!


thanks 
Nayana Adassuriya

Nuwan · Answer

Hi Nayana,

Use the develpoer menu insert control option to draw a buton & this has to be done using the Form control category, This will automaticaly pop up a window asking to link the macro you have already Created or else right click on the button on non design mood to assign the macro

Assign macro to button on a multi-page tab

2 responses

Similar discussions

Subscribe To Our Newsletter!