Checkboxes in Excel - Please Help!

T

TotallyConfused

I have several checkboxes in a form that I need to have the "True" or "False"
be filled in the database for this form. How do I do this?
 
R

Ron de Bruin

Hi TotallyConfused

I don't think i understand you but with code you can change the
checkboxes like this

Sub test1()
'control toolbox controls
For Each obj In ActiveSheet.OLEObjects
If TypeOf obj.Object Is MSForms.CheckBox Then
obj.Object.Value = False
End If
Next
End Sub


Sub test2()
'forms controls
ActiveSheet.CheckBoxes.Value = False
End Sub
 
T

TotallyConfused

Ron thanks for responding. I am not having problems with checking or
unchecking the checkboxes in my form. What I need is to have the outcome of
the checkbox which would be a check or uncheck to export to the database
linked to this form. So when I save my form and create a new record a True
or False will be populated in the corresponding columns in the database. Or
is there another way to do this?
 
R

Ron de Bruin

If you use a checkbox from the controltoolbox you can use
linkedcell in the properties.

Copy this cell also to your database then
 
Top