View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Checkbox Question

There are 2 different kinds of option buttons and they are found in
different locations, the Forms Toolbar and the Control Toolbox.

Those in the Control Toolbox are designed to be used with VBA code. You
should use the option buttons from the Forms Toolbar.

Right click any toolbar and then select Forms. You'll see the option button.

Biff

"slow386" wrote in message
...
I may be looking in the wrong location, but - - - my option buttons do not
have a tab for Format Control and a cell link location !!
I'm using Excel 2003 with SP2 on XP-Pro with all SP's

I checked two other machines in the office, and they both have the proper
tab.

Any thoughts??

"JMay" wrote in message
...
You want to use option buttons, not checkboxes.


"slow386" wrote:

Hi Folks:

I have a sheet with two checkboxes for the selection of two options
(that
can not be used together).
Is there a way that if for example, box A is checked, box B is unchecked
??

Thanks much
Steve