#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Check Box

I have a worksheet that I am using to keep track of payments made. I want to
make the cells checkboxes but I want the checks to print when I print the
document.

I cannot even figure out how to create the text box.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Check Box

An alternate method.

Format the cells to Marlett font then simply type lowercase "a"

If you want a checkbox, open the Forms Toolbar and select the checkbox.

Draw it where you want then right-click on the edge and Format
ControlProperties.........chackmark in "Print Object"


Gord Dibben MS Excel MVP

On Sun, 3 Aug 2008 17:16:01 -0700, Jffphll08
wrote:

I have a worksheet that I am using to keep track of payments made. I want to
make the cells checkboxes but I want the checks to print when I print the
document.

I cannot even figure out how to create the text box.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default Check Box

hi
if you have a lot of checks, a checkbox may be more trouble than it's worth.
instead you could format the column that you intended for check boxes to the
font
"Marlett" . you could then use the lower case letter "a" to produce a check.
font format "wingdings2" - upper case P produces a check and upper case R
produces a check inside a square. all of these should print on any standard
printer.

Regards
FSt1

"Jffphll08" wrote:

I have a worksheet that I am using to keep track of payments made. I want to
make the cells checkboxes but I want the checks to print when I print the
document.

I cannot even figure out how to create the text 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
Increase size of a Forms Check Box (click on to enter check mark) 718Satoshi Excel Discussion (Misc queries) 0 August 17th 07 01:52 AM
Check if Conditional Format is True or False / Check cell Color Kevin McCartney Excel Worksheet Functions 5 June 29th 07 11:12 AM
How do I increase the size of check in check boxes Adams, Les Excel Discussion (Misc queries) 0 September 19th 06 02:35 PM
Enable check box in protected sheet + group check boxes Dexxterr Excel Discussion (Misc queries) 4 August 2nd 06 12:00 PM
check box, so when you click on it it inserts a check mark into t. Steve Excel Discussion (Misc queries) 2 April 13th 05 09:12 PM


All times are GMT +1. The time now is 10:07 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"