importing results from a checkbox

I'm working with a macro to import specific cell data from many single standardised excel files into a master file.

Problem im having is with these single files contain "Yes" or "No" checkboxes and i require the answer (either yes or no) to pull through into the master file.

Is this possible as the checkboxes aren't physically in the cell, is there perhaps a simpler way im missing?

inserted current code below (only relevant sections included)

Please Login or Register  to view this content.

Are the checkboxes linked to cells?

You'll need to use the Shapes collection of the worksheet(s) to get the values if the checkbox(es).

PS Forms chevkboxes can have linked cells.

This will loop through all the shapes on Sheet1, if they are checkboxes it will output their value - 1 for checked and -4146 for unchecked.

Please Login or Register  to view this content.

I don't really know too much about the sheets you are dealing with but if you always want the values from specific checkboxes you coudl use there names.

Please Login or Register  to view this content.

Have you checked the name?

Is it definitely a Forms checkbox?

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

Select the checkbox and it's name will appear in the name box next to the formula bar.

Glad it worked.