Hi,
Originally Posted by
mitko007
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.
Originally Posted by
mitko007
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 :
So, based on you uploaded workbook, the formula to get the code of cell C2 is :
it will return 10007
and to do the checking :
Regards
Bookmarks