Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CHECK BOX

Status
Not open for further replies.

gvishal

MIS
Oct 9, 2001
14
0
0
US
hOW DO WE ENABLE THE CHECK BOX IN EXCEL
 
what are you trying to do? Adding a checkbox by itself "enables" it, but if you have nothing behind it like some VB code/macro, then it won't do anything.
 
gvishal,

It's part of the "forms" toolbar, which you should probably add to the top of your screen, if you haven't already.

To do this, right-click on the existing toolbar area, and choose "Customize" from the pulldown menu.

Under "Toolbars", check off "Forms".

Then drag the toolbar to the top of your screen.

If you want a check-box in your worksheet itself, just drag it (the one with the check-mark) to the worksheet.

Once in your worksheet, you can adjust the size, and move it around.

To set it up, you need to right-click on the check-box, and choose "Format Control", or you could choose "Assign Macro", depending on your objective.

I hope this gets you started.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top