Excel VBA question about retrieving Ascii character or code

[Keebellah]

Hi guys,
I've got the following Issue
I have a macro that retrieves several tables form a Word document.
In this word document there are checkboxes that the user can either check or uncheck
Like this:
☐ Algemeen belang
☒ Gerechtvaardigd belang

When the table is copied to Excel I need to identify the checkboxes and see if it's checked ot not
The cell content in the Excel is read as string and when I check the the character I only het the following and am not able to identify the first character, I just het a ? instead

? Algemeen belang
? Gerechtvaardigd belang

How can I identify it, or should I identify it first in Word and then only copy the cells from the tables there that have a checked checkbox?
Any hint or idea is welcome.
I'm sure it's something simple but just can't lay my finger on it

 

[Peter_SSs]

Does this help?

21 05 15.xlsm
	A	B
1	☐ Algemeen belang	9744
2	☒ Gerechtvaardigd belang	9746
Check

Cell Formulas
Range	Formula
B1:B2	B1	=UNICODE(A1)

 

[Keebellah]

Thanks Peter,
I’ll try it out when I’m back home
I thought I had tried the Unicode variant at least it give me the difference which is edgy I needed

 

[Keebellah]

Hi Peter,
Thank you, that did the trick, knew it had to me something simple, just looked the wrong way.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.