ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Check Box (https://www.excelbanter.com/excel-discussion-misc-queries/197398-check-box.html)

Jffphll08

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.

Gord Dibben

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.



FSt1

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.



All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com