How to write Greek letters in VBA?
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?
Re: How to write Greek letters in VBA?
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 ".
Re: How to write Greek letters in VBA?
use the character value for ᴩ
Re: How to write Greek letters in VBA?
Thanks. I wait it works inside "selectcase" and ".find()"; however, it's showing "?" yet in this code:
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?