I am trying to create a worksheet that contains a yes/no option by inserting a check mark in a box.
D Dakota Bleu Dec 14, 2005 #1 I am trying to create a worksheet that contains a yes/no option by inserting a check mark in a box.
D David McRitchie Dec 19, 2005 #2 You could use a font character for the checkmark, some choices in http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm#ticks Format Column A as "Wingdings 2" and use a "P" for the checkmark, or choose a different checkmark from the above chart. Then change row 1 or cell A1 to normal font perhaps bolded. Right click on the spreadsheet tab, view code and place the following event code there you can take a choice of double-click event at http://www.mvps.org/dmcritchie/excel/event.htm#ticks.
You could use a font character for the checkmark, some choices in http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm#ticks Format Column A as "Wingdings 2" and use a "P" for the checkmark, or choose a different checkmark from the above chart. Then change row 1 or cell A1 to normal font perhaps bolded. Right click on the spreadsheet tab, view code and place the following event code there you can take a choice of double-click event at http://www.mvps.org/dmcritchie/excel/event.htm#ticks.
