Create Multiple Command Button Assign to different macros

**Konexcelmath** · 09-13-2013, 06:28 AM

Hello, i need you help again.
Please for it

I have a workbook with 12 sheets (from 9 to 8 as: 9,10,11,12,1,2,3,4,5,6,7,8)
In each sheet (9-8) i have to run 4 different macros that run after i press the respective command button. So in every sheet i have 4 command buttons. How can i create these 4 command buttons at each sheet and each of them to be assigned to specific macro at once?

Please for your help!!

**tony h** · 09-14-2013, 05:40 AM

I am not quite sure what you are wanting to do.

To create the first four command buttons I assume you have used Insert Shape .. eg a circle and then right-clicked on it to assign the macro.

You can then select the shapes (right click on the first then ctrl+righClick for the next you can then copy ctrl+C move to the next sheet and paste ctrl+V

This will have copied and pasted the shape and its assignment of the macro.

If you use Record macro (from the view menu) when you do the copy and paste (and then stop recording) you will be able to see how you may automate this

Create Multiple Command Button Assign to different macros

LinkBack

Thread Tools

Rate This Thread

Display

Create Multiple Command Button Assign to different macros

Re: Create Multiple Command Button Assign to different macros

Thread Information

Users Browsing this Thread

Similar Threads

Assign two macros to a command button, but only one can automatically run!!

Macro to create Command Button and assign code

Add command button to assign "shortcut" macros

How to create a command button and assign code to it using VBA?

[SOLVED] how to create a command button, then assign macro to it in excel

Bookmarks

Bookmarks

Posting Permissions