+ Reply to Thread
Results 1 to 5 of 5

Option Button to call macro

  1. #1
    Registered User
    Join Date
    04-20-2014
    Location
    Derby
    MS-Off Ver
    Excel 2010
    Posts
    59

    Option Button to call macro

    Good afternoon,

    I have found this piece of code, but instead of calling a message box I would like it to call a macro, I have 4 macros, when I select an option button then click the command button, I would like the corresponding macro to be called.

    any help would be great.

    DeeK

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by deek; 07-13-2016 at 02:31 PM. Reason: Added Example

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Option Button to call macro

    How are the option buttons related to the macros?

    An attachment would help...
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    04-20-2014
    Location
    Derby
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Option Button to call macro

    Good point, I have added an example WB, the macros are only message boxes, this is just for the example not the actual worksheet.

    thanks.

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Option Button to call macro

    That doesn't really help....

    Which property of the Option Button controls which macro is called?

  5. #5
    Registered User
    Join Date
    04-20-2014
    Location
    Derby
    MS-Off Ver
    Excel 2010
    Posts
    59
    Quote Originally Posted by Olly View Post
    That doesn't really help....

    Which property of the Option Button controls which macro is called?
    That is the problem, I don't know enough about properties to manage to get the option bution to control the macro. In the example, I have just added the test macro.

    Derek

+ 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. [SOLVED] Call a macro within a button from a module
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-27-2015, 02:29 PM
  2. Auto call macro without pressing button
    By skhari in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-17-2015, 08:56 PM
  3. [SOLVED] Call Form Control Option Button within an If statement
    By SonOfOdin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-03-2012, 02:23 PM
  4. call macro using button
    By tink_ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2007, 07:19 PM
  5. Call macro via command button
    By lokechoiwun in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2006, 03:59 AM
  6. Custom button to call a macro in Personal
    By David Walker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2006, 06:50 PM
  7. [SOLVED] Call Userfor and click button with macro
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2005, 01:06 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