Excel Issues

[tdfreeman]

I am trying to run code to determine which checkboxes are checked. This Excel file was created by non-technical staff and I am trying to update it so that the data can be loaded into Microsoft Access.

The form has checkboxes on one worksheet and I need to determine the values. So, I created the following code as a test my references to the checkboxes and will modify it once I get it working:

Public Function LoanServicerCheckBox() As Boolean
On Error GoTo Err_LoanServicerCheckBox
    Debug.Print "CheckBox1: " & checkbox1
    Debug.Print "CheckBox10: " & checkbox100
    Debug.Print "CheckBox6: " & checkbox6

 
Exit_LoanServicerCheckBox:
Exit Function
Err_LoanServicerCheckBox:
MsgBox "LoanServicerCheckBox: " & Err.Description & Chr(10) & " Date Passed: " & dtValue
Resume Exit_LoanServicerCheckBox
End Function

My problem is that when I set a breakpoint, the checkboxes are showing Empty, even when I have them checked. Any idea why?

Note: this post is edited from original because I went back and referred to a non-existent (at least I think it is non-existent) checkbox and it returned the same thing. As far as I can tell the checkboxes are not named. How do I find the names for them? I had selected to add a macro to the checkboxes and that is how I had originally guessed their name.

Thank you.

Tammy

 

[tdfreeman]

I may have figured it out. The control is a Form control and in the format options there is a Cell Link. This link is not set. So, since the form has already been sent out, I am probably not going to be able to use this control.

I am writing code to read this Excel file that is being filled out by multiple people. So, I have to load several (probably 50+) and I need an automated way to identify if the control is checked. If anyone has any ideas, I would appreciate them.

Thank you.

Tammy