Assign macro to button on a multi-page tab

[Closed]
Report
-
 Nuwan -
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

2 replies


https://www.ozgrid.com/Excel/assign-macros.htm

This may helpful to you!!


thanks
Nayana Adassuriya
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