International Character (Accentuated) In A Macros

[adamas]

Guys, I'm having a bit of an issue. In one of my Macros some of the text is international. Namely, there's one Croatian letter within a formula:

"U realizaciji (ispla[B]ć[/B]eno)"

And it always translated into:

U realizaciji (ispla[B]c[/B]eno)

So from a character with accent, to a normal/ordinary c letter. This is a problem, because in the table itself it skips values because it's SUPPOSED to be looking for accentuated option (the first one). Is there a way to use accentuated version in Macros somehow?

Character-wise, I assume I need number 263 from here: Alphabet : Croatian
The funny thing is that even if I try to copy paste the accentuated symbol (ć) into Visual Basic Editor of Excel, it copy/pastes ordinary c :/ And again, the problem is that without using accentuated option in the Macro (and hence in the subsequent formula) my workbook doesn't work properly.


Any help would be much appreciated! Needless to say I did some googling on this and keep doing it ofc.

 

[pgc01]

Hi adamas
Welcome to the board

There are several solutions. I'll post 3

1 - using the character code

You can use the character code to write the string, like for ex.:

ActiveCell.Value = "U realizaciji (ispla" & ChrW(263) & "eno)"

2 - using cells with the messages

Another solution, if you have many messages is to add a new worksheet (that you can hide) where you write the messages in cells. This way you can easily read and write the messages and you can reference them in the code:

ActiveCell.Value = Worksheets("Messages").Range("A1").Value

3 - using names that contain the messages

Define a constant name with the message

ActiveCell.Value = ActiveWorkbook.Names("Message_001").Value

HTH