Getting information from clicked "Check Box"

[lamyuwang]

Hello everybody~~

I had prepare a form in MS excel with using "check box", however I forget to link the "check boxs" to the cells and now the form had been filled/clicked.

I need to transfer the information in the form to a table. As I got a lot of forms, nearly 700, It is impossible for me to extract the information manually.

So,I could like to ASK

How can I getting the information from the check box after it was clicked for such hugh amount of forms?? (the forms are saved in the independent file)

I am sincerely hope that some of you can help me for that~~


Thank you very much!!!

 

[SkipVought]

Please post this question in VBA Visual Basic for Applications (Microsoft) Forum707 as it will require a VBA solution.

Also include information about these 700 forms. Are they in separate workbooks, separate worksheets.

Please post a sample of the table that the data needs to populate with information relating the data in the form to the data in the table.

Skip,

_[red][/red]