Insert symbol via VBA

[andymack]

Hi there. I'm looking to try insert a symbol into Excel. The symbol is the delta symbol, 25B2 in unicode (hex). I understand that I can also get the symbol using wingdings 3 and "p" but I wanted to know if there was a way of just adding the symbol. Also, I have tried using the "record macro" funtion to no avail (it returned "?" in the code where the symbol was) and I am using Excel 2003.

Thanks!

Andy

 

[Scott Huish]

Hi, welcome to the board!

Something like this perhaps:

Sub test()
Range("A2") = ChrW(9650)
End Sub

 

[Andrew Poulsom]

You can also hold down Alt and type 286 on the number pad.

 

[andymack]

Hey thanks!!! Works a dream!