Excel form - How create toggle checkmark for Yes or No ?

M

MyVeryOwnSelf

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top