Behavior - Option Buttons

O

Otto Moehrbach

Excel XP, Win XP
I have an option button in each of 4 locations in one sheet. The buttons
are from the Control Toolbox. I want each button to act independently from
the other 3. I also want each button to change its value when clicked upon,
every time its clicked upon.
How do I do this?
Also, where can I go to find an explanation of all the options with all the
controls? Thanks for your time. Otto
 
D

Dave Peterson

If you had multiple optionbuttons (2 or more) at each of those four locations,
then you could change the GroupName property of each optionbutton in that group
to the same string.

But it sounds to me like you shouldn't be using optionbuttons for this. As a
user, I think I would expect to see checkboxes in those 4 locations--it's either
checked or not checked.
 
O

Otto Moehrbach

Dave
After I thought about for a while, I came to the same conclusion.
Thanks. Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to enumerate buttons on user form 2
Weird option button behavior 3
Bizarre option button behavior 2
De-Select an Option button 3
Option buttons not responding 6
Accessing groups of option buttons 4
option button (Form) 2
Capturing YES/NO from two option buttons 3

Top