Numeric Value of Symbol

[Michael151]

Hello all,

As part of a macro, I'm trying to insert a musical note (♫) in certain parts of a worksheet. I can cut and paste this musical note, but I'm trying to find the character number or way I can use visual basic to do this.

I have found the number for this symbol is 9835 (at least with ascii code), but having trouble getting it work with Visual Basic.

Anyone have any ideas? Is there a specific way to write this so VB recognizes this number as a symbol?

Thanks for the help!

 

[Gary McMaster]

Use ChrW for unicode.

ActiveSheet.Range("A1").Value = ChrW(9835)

Gary

 

[bertie]

Try this:

Sheets("sheet1").Range("a1").Value = ChrW(9835)

Edit: Oops, too late.

 

[Michael151]

Wow...thanks for the quick replies guys! That worked! Learn something new everyday...