inserting unicode characters

[jordanh]

hi,

Is there any way of inserting a unicode character by its u/c id (eg 'fb01')?

I'm setting up some keyboard shortcuts for characters such as the degree symbol, angled brackets and fi/fl ligatures using macros similar to this ...

Sub dguilll()
Selection.TypeText Text:="«"
End Sub

with the double guillemot copied and pasted for Win 2000 character map. If I try and do this with some symbols however (eg fi/fl ligatures, unicode fb01 and fb02) it just pastes a question mark in to the VB editor.

Does anyone know a way of replacing "symbol" with its unicode character reference? (note, Chr(fb01) doesn't work).

Thanks in advance for your help.

jordan

 

[ETID]

Try CHR$(the ascii decimal value of the character)

Example: CHR$(65) returns the capital letter "A"