Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dakota Bleu
 
Posts: n/a
Default how do i create a macro for putting a check in a box?

I am trying to create a worksheet that contains a yes/no option by inserting
a check mark in a box.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David McRitchie
 
Posts: n/a
Default how do i create a macro for putting a check in a box?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create automatic macro with if statement or similar betatryck_se Excel Discussion (Misc queries) 2 December 14th 05 11:32 AM
Macro to Create a Chart and Update it Automatically maperalia Charts and Charting in Excel 2 October 21st 05 05:42 PM
Create a print macro that would automatically select print area? wastedwings Excel Worksheet Functions 7 August 22nd 05 10:36 PM
Create Excel macro for barcode output hugo Excel Discussion (Misc queries) 1 March 4th 05 04:52 PM
How do I create a macro of editing keystrokes? scjanner Excel Discussion (Misc queries) 0 January 21st 05 11:07 PM


All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"