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