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!

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.

--
Regards,
Tom Ogilvy


"Darin Kramer" <(E-Mail Removed)> wrote in message
news:uwKk%(E-Mail Removed)...
> 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!

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)


"Darin Kramer" <(E-Mail Removed)> wrote in message
news:uwKk%(E-Mail Removed)...
> 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!