Thank you so much for your help!
Karen

"Roger Govier" wrote:

Hi Karen

You could use some event code - like double click.
The following code is based upon column D, change the column number to suit
your requirement.
On double click, the code checks to see if the cell is empty. If it is, it
formats the cell to Marlett and inserts an "a"
If the cell already contains a character, it deletes it and sets the font
back to Arial. Either change the font to your standard, or remove the line
altogether if you are happy for the font to remain as Marlett.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Column < 4 Then Exit Sub ' choose column Number
If Target.Count 1 Then Exit Sub
If Target.Value = "" Then
Target.Font.Name = "Marlett"
Target = "a"
Else
Target.Font.Name = "Arial" ' set to your normal default font
Target = ""
End If
End Sub

Copy the Code above
Right click Sheet tab View Code
Paste code into white pane that appears
Alt+F11 to return to Excel

--
Regards
Roger Govier

"Karen" wrote in message
...
Thanks! That is a cool trick! I will definitely use that for future.
Although, several people will use this form and users would get confused
(I'm
guessing) if I tell them to enter a lowercase b. Any other suggestions?
Thanks, Karen


"FSt1" wrote:

hi
format the cell to font Marlett then enter a lower case a or lower case
b.
this will but a check mark in the cell and the font size and be increased
or
decreased to suit.

regards
FSt1

"Karen" wrote:

Using Excel 2003 - Is there any other way to simulate a check box in a
cell?
I have a form that I want users to be able to check a box for a certain
request. I cannot use the check box because when I print it, it's too
small.
Is there any other method to use?
Thanks to everyone who has helped me on this message board. Everyone is
ALWAYS so helpful.
Karen