How do I make a box with a check mark when clicked?

[SongbirdVL]

I am trying to create a form that has boxes in which people can enter a check
mark by simply clicking on the box, no text required. I'm using Excel 2003.

 

[Rick Rothstein]

When you say "form", do you mean a UserForm or a worksheet setup to look
like a "form" to be filled in?

Do you plan to interact with the CheckBox (what you appear to be describing)
or is it just there for viewing? If you plan to interact with it, tell us in
what way so we can guide you in doing it.

 

[SongbirdVL]

I do plan to interact with the checkbox. I don't know what UserForm is and
was planning to create a worksheet to look like a form.

The worksheet will be used to do monthly inventory at my office with 3
checkboxes for each item (yes, no, n/a).

Thanks for your help.

 

[Rick Rothstein]

I'm sure you will be back with a "how do I do this" type question for the
part when you try to use the CheckBoxes. Below is where you can get
CheckBoxes from (there are two available; however, be alerted that depending
on what functionality you want to have, one CheckBox may be more desirable
than the other). The two places you can get ChectBoxes from are the Forms
toolbar and the Control Toolbox toolbar. If these toolbars are not currently
displayed, you can get them to be displayed by checking the appropriate
toolbar item on Excel's View/Toolbars menu item. The controls look the same
(but they are entirely different in how you can interact with them)... a
square with a checkmark in them. Just click on the icon and then click/drag
on your worksheet to place whichever icon you clicked on.

 

[SongbirdVL]

PERFECT! No more questions, this was exactly what I needed to know. Thank
you very much!!