Excel VBA question about retrieving Ascii character or code

Keebellah

Board Regular
Joined
Feb 4, 2014
Messages
79
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
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
49,413
Office Version
  1. 365
Platform
  1. Windows
Does this help?

21 05 15.xlsm
AB
1☐ Algemeen belang9744
2☒ Gerechtvaardigd belang9746
Check
Cell Formulas
RangeFormula
B1:B2B1=UNICODE(A1)
 
Solution

Keebellah

Board Regular
Joined
Feb 4, 2014
Messages
79
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

Board Regular
Joined
Feb 4, 2014
Messages
79
Hi Peter,
Thank you, that did the trick, knew it had to me something simple, just looked the wrong way.
(y):)
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
49,413
Office Version
  1. 365
Platform
  1. Windows
You're welcome. Thanks for the follow-up. :)
 

Forum statistics

Threads
1,136,284
Messages
5,674,836
Members
419,529
Latest member
TommasoP11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top