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:
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
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:
Code:
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
Last edited by a moderator: