kjacw
Board Regular
- Joined
- Jun 29, 2010
- Messages
- 144
Hello All,
I am using Excel 2013 and I would like to know how to have my message box to pop up the value of a cell that has a different language.
In cells C2 and others, for example I have a words in Greek.
When I am entering in the words I change from English font to a Greek font and type the Greek word
I have a macro that gives me the word from that cell but not in Greek. I'm wanting to create a New testament Greek vocab quiz and I would like to have my message box to show that word
Thanks in Advance
I am using Excel 2013 and I would like to know how to have my message box to pop up the value of a cell that has a different language.
In cells C2 and others, for example I have a words in Greek.
When I am entering in the words I change from English font to a Greek font and type the Greek word
I have a macro that gives me the word from that cell but not in Greek. I'm wanting to create a New testament Greek vocab quiz and I would like to have my message box to show that word
Rich (BB code):
Sub Whats_In_A_Cell()
Title = """GREEK VOCABULARY"""
Message = " What is this word? " & Chr(13) & _
Chr(13) & Range("C2")
Style = vbONLYOK + vbQuestion
Response = MsgBox(Message, Style, Title)
End Sub
Thanks in Advance