Load characters into a character array.

[Engineer Joe]

I'm making a string array to reference for a combo box in a user form. It should be this:

Array("=","<",">","≥","≤")

However, if you'll notice, the last two characters (≥ and ≤) won't go into the array in the vbe. A simple copy/paste into the vbe yields last two characters as equal signs (=), just try it.

Furthermore, the ASCII code for ≥ is ALT+242, but entering that directly into the vbe also yields the equal sign. So the question is, how do i load these characters into the array above when the vbe simply doesn't recognize them?

Thanks in advance.

 

[Rick Rothstein]

Those symbols are not part of the normal ASCII range (that is, non-Unicode range) of most fonts. However, I have a Symbol font on my system (which I believe is standard for all Windows operatiing systems) which does support those characters in the normal ASCII range. So, go to the Properties window for you ComboBox and change its font name to Symbol, then use this code line to assign the symbols to its item list...

ComboBox1.List = Array("=", "<", ">", "£", "³")

Yes, the last two characters will look wrong, but they will have the correct ASCII code of the symbols you want in the Symbol font.

 

[gregtx81]

Also

Array("=", "<", ">", ChrW(&H2264), ChrW(&H2265))