Check Boxes / Option Buttons....

[Darin Kramer]

For some reason my Check box that I insert via the control toolbox, does
not have a TAB entitled "Control"
Can someone create a blank check box in excel and send it to me via
email... or advise how to make my control option visible...?

I need to give a user a choice of one or more than one (max 4) optins to
select...

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Tom Ogilvy]

When you right click on it, select properties. If you want to set it as
checked or unchecked, you would use the value property and set it to True or
false. It also has a linkedcell property.

The control tab is found for Checkboxes from the forms toolbar.

 

[Bob Phillips]

Darin,

It is from the control toolbox, you don't get that selection, it is driven
by event code within that worksheet.

If you want the forms checkbox, go to View>Toolbars>Customize, select the
toolbars tab, check Forms, and drag the checkbox onto the worksheet.
Right-clicking it will get what you describe.

--

HTH

RP
(remove nothere from the email address if mailing direct)