Forum

Notifications
Clear all

Option Buttons on Worksheet

3 Posts
2 Users
0 Reactions
65 Views
(@kjbox)
Posts: 69
Trusted Member
Topic starter
 

Is it possible to have multiple ActiveX Option Buttons on a sheet and have 2 of the showing "True"?

I have tried separating them by both Group Boxes and ActiveX Frames, neither works.

 
Posted : 28/01/2021 10:41 pm
(@kjbox)
Posts: 69
Trusted Member
Topic starter
 

I discovered that if I separate the Option Buttons into ActiveX controls and Form controls then one group does not communicate with the other so I can have one of each showing "True".

Not the ideal solution for me but a usable workaround.

 
Posted : 29/01/2021 4:44 am
(@debaser)
Posts: 837
Member Moderator
 

I would advise against using activex controls unless they have a particular functionality you need, but to address your question specifically: optionbuttons have a groupname property that you can use to separate them into groups - eg have two with groupname Group1 and two with groupname Group2 and one group will not affect the other.

 
Posted : 30/01/2021 5:59 am
Share: