Displaying symbols programmatically

[Cyberdude]

I'm not sure I understand what you mean by a 'tick' mark, but I use 'check' marks a lot by entering an uppercase "P" and use the "Wingdings 2" font. Here's a little utility that I use. This utility requires that you click on the cell where you want the check mark, then execute the macro (which I do with a button):

Sub InsertCheckMark()    ' 7/23/02
    ' Inserts a check mark into the selected cell
    With ActiveCell
        .Value = "P"
        .VerticalAlignment = xlTop
        .HorizontalAlignment = xlCenter
        .Interior.ColorIndex = White
        With .Font
            .Name = "WingDings 2"
            .ColorIndex = Black
            .Size = 12
            .Bold = False
        End With
    End With
End Sub

Try it . . . you'll like it!