If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I make a box with a check mark when clicked?
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. |
#2
|
|||
|
|||
How do I make a box with a check mark when clicked?
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. |
#3
|
|||
|
|||
How do I make a box with a check mark when clicked?
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
How do I make a box with a check mark when clicked?
PERFECT! No more questions, this was exactly what I needed to know. Thank
you very much!! "Rick Rothstein" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|