View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default How do I make a box with a check mark when clicked?

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.

--
Rick (MVP - Excel)


"SongbirdVL" wrote in message
...
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" wrote:

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.

--
Rick (MVP - Excel)


"SongbirdVL" wrote in message
...
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.