Excel VBA need check mark character to show in cell... 1

[DougP]

we need a check mark to show on a report card for lower grades.
but when I paste teh Character they use in the VBA code is changes it to a quation mark.

ActiveCell.Value = "?" ' CHECK MARK

how can I make it a square root sign which is what they are using now.
the font for the cell is Arial.
I dont see a ASCII symbol for a square root either?

DougP

 

[SkipVought]

hi,

Have you checked Insert > Symbol?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[DougP]

this is in the VBA code not the cell itself

ActiveCell.Value = "?" ' CHECK MARK

need to replace the? with a square root symbol

DougP

 

[SkipVought]

My question stands.

Have you found the FONT & CHARACTER?

Do some heavy lifting. That's EXACTLY what I or any of us would have to do to answer YOUR question.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

A starting point:

With ActiveCell
  .Value = "Ö"
  .Font.Name = "Symbol"
End With

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886