ActiveX vs Forms

  • Thread starter Thread starter King
  • Start date Start date
K

King

Hello-

I am trying to embed some option buttons on a worksheet. I want to
have two sets of buttons which are mutually exclusive, say A-D and
then 1-3. I want to start with 1-3 hidden and if the user chooses
option D from the first set then 1-3 will be revealed. I did this fine
with the activex option buttons and VBA, however, it is not
recognizing A-D and 1-3 as separate groups. Therefore, as soon as the
user select 1,2 or 3, it will uncheck D and therefore rehide the
remaining numbered boxes. I grouped and named each set of buttons
together, but that did not work. If I try to use a group box and
option buttons from the forms toolbar then I cannot assign code to
them. Please help or point me to a good reference source.

Thanks!
 
Hi King,

Draw a Group Box from the 'Forms' toolbar on your sheet over the Option
Buttons. Make sure your Option Buttons is from the 'Controls' toolbar.
Next set the GroupName property of these Option Buttons to the name of
the Group Box. Do the same for the other Option Buttons with a
different Group Box.

Hopefully it will work..
 
If you use the Forms option buttons, you assign a macro by
right-clicking the button and choosing "Assign macro"
 
I don't think you even need the groupbox. Just give each set of option buttons
a different groupname.

(the groupbox may make it look prettier, though.)
 
Back
Top