check mark in box...how to

[Juco]

when I do a shopping list for example and there is a long list of items how
would I check the items I want bought, currently I put a Y (for yes) in the
box.
I am talking about the type of `check` below ( without the broken line)

/
\/

thanks

 

[Peo Sjoblom]

Format the check mark range as Marlett fonts and use "a" instead of "Y"

 

[Paul B]

Juco, if you want to use a macro you could also put in a check mark when you
select the cell, like this, put in worksheet code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Will put a check mark in A1:A100 upon selection
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A1:A100")) Is Nothing Then
Target.Font.Name = "Marlett"
If Target = vbNullString Then
Target = "a"
Else
Target = vbNullString
End If
End If
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[Bill Sharpe]

Wing-Ding font, Alt-0254 will give you a check mark in a box. Your "Y" is
easier to enter but perhaps not as ascetically pleasing...

Bill