Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Techguy Sr eng.   on Oct 09 In MS Office Category.

  
Question Answered By: Logan Bouchard   on Oct 09

Sorry... I guess my explanation WAS too verbose.
If you want to allow multiple selections, that's easy to do.
Just DON'T use a GroupName.
Then each option  button is independent.
then the code is like:

Userform.hide
'----------- --------- --------- -
if (Userform.Opt_ Macro1.value) then
'(run Macro associated with Macro 1)
end if
if (Userform.Opt_ Macro2.value) then
'(run Macro associated with Macro 2)
end if
if (Userform.Opt_ Macro3.value) then
'(run Macro associated with Macro 3)
end if
'----------- --------- --------- -
Unload Userform

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Option Buttons to choose which macros to run Or get search suggestion and latest updates.


Tagged: