Help inserting SYMBOLs in VBA

  • Thread starter Thread starter Ed Landau
  • Start date Start date
E

Ed Landau

Using Insert -> Symbol, I am able to insert symbols into a worksheet.
How can I do this programiatically from VBA?
I've tried recording a macro to see but running that same macro inserts a
question mark ("?") instead of the symbol I inserted when recording the
macro.

Thanks
-Ed
 
Take some notes when you do it manually--keep track of the codes you're using.

This worked ok for me:

With ActiveSheet.Range("e1")
.Value = Chr(38)
.Font.Name = "Wingdings"
End With
 
Thanks.... but that works for values up to 255. I'm looking for Unicode
06DE (hex).

-Ed
 
Back
Top