Making greater than or equal to as part of the header string

[welchs101]

Hi,

I have a header string that i want to have greater than or equal to inserted into a cell via vba. But i am having issues.


For example: I would like to have the following in cell A1:
"X ≥ 30"

But i cant seem to get the get it to work.............again this is to be done via VBA..........

any one know how?

[JOHN H. DAVIS]

Not sure if this is what you're looking for:

Please Login or Register  to view this content.

[welchs101]

john thanks but not that is not what i am looking for.......i am looking for the greater than on top of the equal sign..........not beside it.

[JOHN H. DAVIS]

I think you'd have to find the associated ASCII symbol. I had no luck. If you do then it would be something like this.

Please Login or Register  to view this content.

[welchs101]

so you have the same problem that i did...........makes me feel somewhat better but there has to be a way to do this..........right?

[jindon]

See if this works

Please Login or Register  to view this content.

[welchs101]

jindon, thanks but that does not work either. It puts a question mark "?"..........

[JOHN H. DAVIS]

so you have the same problem that i did...........makes me feel somewhat better but there has to be a way to do this..........right?

Should be. I can do it manually. There is a symbol for that in the selection.

[jindon]

How about 8805?

[welchs101]

nope......i am enclosing the macro i am using to test this........its fairly simple but i could be doing somthing wrong thus the reason for the post.

[Izandol]

Did you test the suggestion in fact?

Please Login or Register  to view this content.

Msgbox does not understand unicode.

[jindon]

You can't show that in msgbox.

Have you tried

Please Login or Register  to view this content.

[welchs101]

i knew i was doing something wrong........

that was it.........i cant use msgbox to identify what i should do................

thanks all................i did as you "litterally" suggested and it worked.

sorry for the confusion

[JOHN H. DAVIS]

Please Login or Register  to view this content.

Works for me!

[jindon]

OK and thanks for the rep.

Just for your info.

8804 should give you smaller than symbol. ≤