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

more info:

the value of string is its unicode value

Nick wrote:

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

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


"Nick" wrote in message
...
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