Checkboxes in Excel - Please Help!
 

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?

Checkboxes in Excel - Please Help!
 

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"TotallyConfused" wrote in message
...
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?

Checkboxes in Excel - Please Help!
 

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?

"Ron de Bruin" wrote:

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"TotallyConfused" wrote in message
...
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?

Checkboxes in Excel - Please Help!
 

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

Copy this cell also to your database then

--
Regards Ron de Bruin
http://www.rondebruin.nl


"TotallyConfused" wrote in message
...
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?

"Ron de Bruin" wrote:

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"TotallyConfused" wrote in message
...
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?