I have lots of word documents that has FormField checkboxes (using the Forms toolbar) in it and I was trying to transfer that value to an excel file to file a report.

My problem is that FormField checkboxes (using the Forms toolbar) doesn't have any bookmark value. How can I get the data from the check boxes using VBA codes.

Please help me...


Simply the best...

If you have used the form field

Try

If .FormFields(CheckBoxName).Result = True
  ' Move it to Exce;
End if

This Should work

or you can use

chkCheckBoxName.Checked = True


Cheers
Shasur


http://www.vbadud.blogspot.com

Thanks for the help, I will try this...:)

Simply the best...