Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel form - How create toggle checkmark for Yes or No ?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel form - How create toggle checkmark for Yes or No ?
How create toggle checkmark for Yes or No
Here's one way. First open the "Forms" toolbar. Click on the checkmark picture in the toolbar, then on the place in the spreadsheet where you want it to go. This creates a new checkmark object in the sheet. Right-click on the new object and select "Format Control." This brings up a dialog box to change the appearance of the object. In addition, the "Control" tab of the dialog box can link the checkmark to a spreadsheet cell where the state maintained. It's TRUE/FALSE but (if needed) a reference to it by a formula in another cell can produce Yes/No or other useful representation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a form in excel so I can enter data using DataForm | Excel Discussion (Misc queries) | |||
I am trying to create a form in Excel. In my form I want to be abl | Excel Discussion (Misc queries) | |||
Checkmark box in Excel | Excel Discussion (Misc queries) | |||
make toggle checkmark box | Excel Discussion (Misc queries) | |||
How do I set up a checkmark box in Excel? | Excel Discussion (Misc queries) |