Hello --

On 2002-11-25, PeterDavey )
posted a method to allow douple-clicking a cell to change its value, and
mentions Monotype Sorts as a font to simulate a tick mark.

Does anyone know of a font distributed with Win2000 or otherwise in the
public domain that would have a similar mark, and, how I would use VBA to
test for its value once I got it to work?

Thanks for any help.

Larry Mehl

-------------------------------------
Subject: Newbie: Put CheckBox in a cell and use it to set that cell's
value?

I use the following code in a worksheet to "toggle" the value of a cell in
the named range "sendFlags" between True and False when the cell is double
clicked.

It doesn't look as nice as as a checkbox but it works OK. If you
wanted to display a tick instead of True you could for e.g. use the Monotype
Sorts font and set the value to 4.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel
As Boolean)
If Not Intersect(Target, Me.Range("sendFlags")) Is Nothing Then
Cancel = True
If Target.Value = True Then
Me.Range(Target.Address).Value = False
Else
Me.Range(Target.Address).Value = True
End If
End If
End Sub

Hi,

...a font to simulate a tick mark.

I use character "a" of Font "Marlett".

arno

some more choices of tickmarks in fonts, see
http://www.mvps.org/dmcritchie/rexx/...bols.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

"arno" wrote .
...a font to simulate a tick mark.
I use character "a" of Font "Marlett".

Arno and David --

Thanks for the ideas. I think I will use the "a" in Marlett for the
tickmark and blank for a blank. I like the bold-appearing look of the "a".

Larry

"L Mehl" wrote in message
...
Hello --

On 2002-11-25, PeterDavey )
posted a method to allow douple-clicking a cell to change its value, and
mentions Monotype Sorts as a font to simulate a tick mark.

Does anyone know of a font distributed with Win2000 or otherwise in the
public domain that would have a similar mark, and, how I would use VBA to
test for its value once I got it to work?

Thanks for any help.

Larry Mehl

-------------------------------------
Subject: Newbie: Put CheckBox in a cell and use it to set that cell's
value?

I use the following code in a worksheet to "toggle" the value of a cell in
the named range "sendFlags" between True and False when the cell is double
clicked.

It doesn't look as nice as as a checkbox but it works OK. If you
wanted to display a tick instead of True you could for e.g. use the
Monotype
Sorts font and set the value to 4.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range,
Cancel
As Boolean)
If Not Intersect(Target, Me.Range("sendFlags")) Is Nothing Then
Cancel = True
If Target.Value = True Then
Me.Range(Target.Address).Value = False
Else
Me.Range(Target.Address).Value = True
End If
End If
End Sub