How to show unicode String ?

[Nick]

Hi,

I have a variable temp which store unicode string(more than 1 char) ,
but how can i display it correctly using vba in excel? Instead of
showing its unicode value?

Thanks

 

[Nick]

more info:

the value of string is its unicode value

 

[Chip Pearson]

You could try using the StrConv function. E.g.,

Dim S As String
S = StrConv(unicode_string,vbFromUnicode)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com