Find/Replace Characters in a string

**Light Pail** · 01-20-2010, 07:02 PM

There is a string "strSearch" which contains characters "&lte;". I would like to replace "&lte;" with "≤", but for some reason it is replaced with "=". The function below works otherwise...the character code is correct. What is the problem here?

Please Login or Register  to view this content.

**quekbc** · 01-20-2010, 07:36 PM

Hi Light Pail,

I used your function, and it seems to be working fine on a spreadsheet.

If you're trying to convert a string to be used in another VBA procedure, I don't think the VBA environment accepts that character.

I could be wrong.

**shg** · 01-20-2010, 07:49 PM

I think the MsgBox shows only the Extended ASCII character set, not Unicode. Cells and textboxes on forms will show Unicode.

**Light Pail** · 01-20-2010, 07:52 PM

I am trying to convert in the VBA environment, before the string is written to a file in a different function. In VBA, the MsgBox (ChrW(8804)) returns an "=" sign as well.

Any resources regarding the limitations of special characters in VBA?

**shg** · 01-20-2010, 08:06 PM

The string contains the correct character; MsgBox maps it to the ASCII character set. To convince yourself,

Please Login or Register  to view this content.

**quekbc** · 01-20-2010, 08:08 PM

Based on shg's comment, you can find a list of supported characters by searching through the magic F1. Search for "character set" (without the quotation marks) and you'll get a list of what's supported.