Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to create a worksheet that contains a yes/no option by inserting
a check mark in a box. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You could use a font character for the checkmark,
some choices in http://www.mvps.org/dmcritchie/rexx/...bols.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. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Dakota Bleu" <Dakota wrote in message ... I am trying to create a worksheet that contains a yes/no option by inserting a check mark in a box. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create automatic macro with if statement or similar | Excel Discussion (Misc queries) | |||
Macro to Create a Chart and Update it Automatically | Charts and Charting in Excel | |||
Create a print macro that would automatically select print area? | Excel Worksheet Functions | |||
Create Excel macro for barcode output | Excel Discussion (Misc queries) | |||
How do I create a macro of editing keystrokes? | Excel Discussion (Misc queries) |