+ Reply to Thread
Results 1 to 2 of 2

Create Multiple Command Button Assign to different macros

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    greece
    MS-Off Ver
    Excel 2010
    Posts
    66

    Create Multiple Command Button Assign to different macros

    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!!

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,186

    Re: Create Multiple Command Button Assign to different macros

    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


    click on the * Add Reputation if this was useful or entertaining.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Assign two macros to a command button, but only one can automatically run!!
    By paulyb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-14-2012, 01:06 PM
  2. Macro to create Command Button and assign code
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2011, 09:19 AM
  3. Add command button to assign "shortcut" macros
    By menksa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2008, 08:43 AM
  4. How to create a command button and assign code to it using VBA?
    By surotkin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2007, 10:05 PM
  5. Replies: 2
    Last Post: 06-05-2005, 11:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1