Question:
I have a workbook that I want to be able to switch back
and forth between Spanish and English. This works for
text in cells on different worksheets where one worksheet
is a sort of dictionary with one language in one column
and the other language in the column next to it. However,
I also would like some way to switch the language used
for cell comments. Can anyone suggest a way to do that?
Answer:
You can change the language in the comments with a VBA macro and a list with
Cell Reference - Spanish Text - English Text.
The basic syntax is
Range("A1").Comment.Text Text:="My text"
Submit Your
Own Answer!
