How to write Greek letters in VBA?

[marlonsaveri]

Hello again.
In a combobox, some items are Greek letters.
By clicking "OK", a chart is generated from data in many sheets through a ".find()" which looks for the contents of the combobox (which may be Greek characters, such as alpha, beta, etc.) and takes the values of cells to construct the chart.

However, I must write the word to be sought not only within ".find ()" but as a case of "Select Case ". So how to proceed?

[marlonsaveri]

For example: it prints "?" instead of the letter "ρ" (rho)

When I do:
myoption = combobox1.text
call maketable(myoption)
and Set CellOK = Worksheets(i).Cells.Find(what:=myoption ...
it's ok, the program finds "myoption" in every cell, mounts the table and builds the graph.
but msgbox myoption returns "?"

I'll only call maketable() if myoption obey some rules of "Select Case ". So I must write the Greek letters in the "Case ".

[westconn1]

use the character value for ᴩ

case chr(63)

[marlonsaveri]

Thanks. I wait it works inside "selectcase" and ".find()"; however, it's showing "?" yet in this code:

Sub msgpho()
    MsgBox Chr(63) + " isn't p; is it ok?"
    Range("A4").FormulaR1C1 = Chr(63)
    Dim str As String
    str = Chr(63)
    Range("A1").FormulaR1C1 = str
End Sub

And, where do I find out which letters represent which numbers?