Symbol - VBA reference - Need help!

[mitko007]

Hi guys,

i have a kind of a strange issue here. I want to write a short macro which should perform some checks in a couple of excel sheets that i'll be receiving. I got an example of the data and instead of yes or nos, ones or zeros it contains ticks and crosses. I'm attaching an example with the two symbols. My question is, first how do i write a symbol like this in excel (i searched through the symbol list but without success) and second and more important how do i refer to these in VBA - e.g. if cell A1 = "the strange tick" --> B2 = "VALID" elseif A1="strange cross" B2 is "NOT VALID"

Thanks a lot,

regardsExp.xlsx

[zbor]

You can write û and ü with font Wingdings.
Then use them as any other letter.

[mitko007]

Hi zbor, thanks for the quick reply. I wrote u with windings and it gives me a tick. However, its not the same tick and thus its not equal to the one i have. I guess it will be the same with the windings cross

[karedog]

Hi,

first how do i write a symbol like this in excel (i searched through the symbol list but without success)

This kind of symbol is unique among different fonts, the quickest way to mimic this symbol is to open the workbook contained this symbol then do copy paste operation, it will copy everything, including the fontname, etc.

and second and more important how do i refer to these in VBA - e.g. if cell A1 = "the strange tick" --> B2 = "VALID" elseif A1="strange cross" B2 is "NOT VALID"

Since this is unicode character, we can use the AscW() function to get the code, I write an UDF to do this :

Please Login or Register  to view this content.

So, based on you uploaded workbook, the formula to get the code of cell C2 is :

Please Login or Register  to view this content.

it will return 10007

and to do the checking :

Please Login or Register  to view this content.

Regards