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

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?

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

Sub welches101()
Range("A1").Value = "X >= 30"
End Sub

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.

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.

Sub welches101()
Range("A1").Value = "X" & chr(..) & "30"
End Sub

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?

Originally Posted by 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?

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

See if this works

    [a1] = "X" & ChrW(8807) & "30"

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

How about 8805?

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.

Did you test the suggestion in fact?

Range("A1").Value = "X" & ChrW(8805) & "30"

Msgbox does not understand unicode.

Range("A1").Value = "X" & ChrW(8805) & "30"

Works for me!

You can't show that in msgbox.

Have you tried

[a1] = "X" & ChrW(8805) & "30"

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

OK and thanks for the rep.

Just for your info.

8804 should give you smaller than symbol. ≤