+ Reply to Thread
Results 1 to 5 of 5

code behind the command button that runs another macro

  1. #1
    Registered User
    Join Date
    07-01-2012
    Location
    Tilburg, the Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    96

    code behind the command button that runs another macro

    Hi,

    I`ve got a button - after clicking on that I want to start running some macro (let`s call it Macro1). How to do that? Simply pasting a Macro1 code to this button`s code doesn`t work...

  2. #2
    Registered User
    Join Date
    06-12-2010
    Location
    Hereford, England
    MS-Off Ver
    Excel 2003
    Posts
    73

    Re: code behind the command button that runs another macro

    Right click the button and select assign Macro. Choose your macro from the list.
    Kind Regards

    Baz

  3. #3
    Forum Contributor
    Join Date
    09-05-2012
    Location
    It's more fun in the Philippines :D
    MS-Off Ver
    Excel 2007
    Posts
    209

    Re: code behind the command button that runs another macro

    Quote Originally Posted by Vogelmann View Post
    Hi,

    I`ve got a button - after clicking on that I want to start running some macro (let`s call it Macro1). How to do that? Simply pasting a Macro1 code to this button`s code doesn`t work...
    @vogelmann

    You could do like this.

    Please Login or Register  to view this content.
    Put inside the event:
    Call <macroName>
    Don't forget to mark your thread as [SOLVED].

  4. #4
    Registered User
    Join Date
    07-01-2012
    Location
    Tilburg, the Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    96

    Re: code behind the command button that runs another macro

    thisisgerald - thanks! that`s what I needed
    Baziwan - there is no option like `assign Macro`after clicking on that button - there are some others like `view code`, `properties` etc.
    Last edited by Vogelmann; 10-10-2012 at 05:58 AM.

  5. #5
    Forum Contributor
    Join Date
    09-05-2012
    Location
    It's more fun in the Philippines :D
    MS-Off Ver
    Excel 2007
    Posts
    209

    Re: code behind the command button that runs another macro

    @vogelmann
    Your welcome!

    Thanks for the rep.

    You may mark this thread as [SOLVED]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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