Displaying symbols programmatically

[muttleee]

Hiyas

I am trying to print a 'tick'/'check' symbol in a particular column of an Excel document if a condition is satisfied. How do I go about doing this programmatically? I think I must have to do something with the font and or charset or something but beyond that I'm clueless.

For regular I just use:

.Cells(row, col)= Value

Currently the only font settings etc are these:

xl.Cells.select
    xl.selection.Font.Name = "Verdana"
    xl.selection.Font.Size = 9
    xl.Rows("1:1").Select
    xl.Selection.Font.Bold = True
    xl.selection.Font.size = 10
    xl.selection.RowHeight = 15        
    xl.Cells.select
    xl.selection.columnwidth = 100
    xl.selection.columns.Autofit    
    xl.selection.rows.Autofit
    xl.selection.VerticalAlignment = xlTop
    xl.ActiveSheet.Range("A1").Select

What changes do I need to make to be able to print a tick/check to an Excel cell?

Thanks in advance.