How do I let only one box be chosen when there are several?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've put several 'check' boxes in a sheet. I want to allow only one to be
chosen. Can anyone help?
 
Don't use checkboxes use option buttons instead as only one can be selected
at a time.

Nick
 
Looked up 'radio' buttons and cannot find it's functionality and how-to.
Where do I find this info?
 
There are two types in excel 2000
Either on the Forms tool bar or the Control Toolbox toolbar.
Right click the current menubar and select the toolbars from there. Or
View - Toolbars.

The Forms option button and the Control option button are different and are
implemented differently but work the same, i.e only one can be selected at a
time.
The Control option button has more functionality through VBA.

Nick
 
do you mean ActiveX control? When I do a search on option buttons, it comes
up with ActiveX and with manipulating the controls of the page. Nothing
about check boxes.
 
The controls on the Control Toolbpx toolbar are ActiveX Controls.
In Excel help serach for 'Types of Controls" and you should see two help
topics. One about Form controls and the other about ActiveX controls.

Nick
 
You must log in or register to reply here.

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

Windows 10 One Drive Problem 2
copy value calendar control 1
Conditional Drop Down boxes 2
How can I choose more than one item from list in a form in Excel? 7
Show Only Fields Needed 0
Excel Move or Copy Stopped Working? 0
IF AND Nested Functions - Formula Not Working 0
IF statement and Combo Boxes 2

Back
Top