How do I insert Check Boxes in Excel? 1

[rglovell]

I have little to no experience with VBA (I can relatively understand what is written and edit it if there is a wrong cell reference or something, but I can't write it and wouldn't know how to start).

What I need is to have a list with check boxes beside each item. I would really like each item to be red until it is checked and then it will be black (or green). Also, need a "clear all checks" button if possible.

I inserted the boxes, but I'm not sure where to go from there. Right now they are just objects that I can't check or uncheck.

Thanks in advance.
R-

 

[Dreamboat]

Please explain how you inserted them...from which toolbar?

Anne Troy
Way cool stuff:

http://www.cafeshops.com/OfficeExperts

 

[rglovell]

I inserted them from the Control Toolbox. I went to View-Toolbars-Control Toolbox and then clicked the check box. It then let me draw it to the size I wanted and write the test for it, but now it's just an object.

 

[rglovell]

I meant that it let me write the text for it - not test. Fat fingers today.

 

[KenWright]

You might be better off with the checkbox from the Forms toolbar. The control toolbox is the new activex stuff, and the forms toolbar has been include for compatibility purposes, but most people seem to prefer that one when they can use it.

When using the control toolbox you have to ensure that you exit design mode using the option on the toolbar, or you will not be able to use it. The forms one is much simpler by comparison and is ready to be used from the word go.

Regards
Ken................

 

[rglovell]

Thanks Ken, that will work for my purposes. I thought it should be easier than I was making it out to be.