View Single Post
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default 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?