How to show unicode String ?

N

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
 
C

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
 
Top