brent.fraser
New Member
- Joined
- Aug 27, 2009
- Messages
- 41
Hey everyone, I am importing content control information in a word file into excel by using a macro in excel. The information is coming across nicely but when the information about a checkbox comes across, in excel, that's what you see, a checkbox (☐ or ☒). Is there any way (formula or vba) to replace all the checkboxes with a yes or a no?
I wrote a formula that works:
but this will add this information to a new column and I would like to replace the information in the existing column (the form has about 200 checkboxes) and I don't want to add a bunch of new columns.
I also toyed with VBA:
but when I try to paste the ☐ in the vba code, I get a "?" so I am assuming it doesn't recognize the ☐ as a valid character.
Any thoughts?
Thanks,
Brent
I wrote a formula that works:
Code:
=IF(G8="☒","YeS","nO")
I also toyed with VBA:
Code:
Range("G1:G100").Replace "&", "No"
Any thoughts?
Thanks,
Brent