so when i use check boxes on update forms I thought they toggled between 1 and 0 depending on if they were checked or not.
well I am having a problem I have 14 check boxes on two different tabs on one update form and when I chec them I dont want anything to happen untill I hit the Update command button that is susposed to take all the new information I put on the userform and upt it to the spreadsheet. So I put the code under
if checkbox = 1 then
range(c3) = "x"
When you check a checkbox you can examine it's property by looking at it's value
i.e checkbox.value = true
since you are using multiple checkboxes on a single user form i would suggest running something like this
Private Sub CmdAll_Click()
Dim aControl As MSForms.Control
'Check which box is checked
For Each aControl In Me.Controls
If TypeOf aControl Is MSForms.CheckBox Then
'check to see if checkbox is checked
If aControl.Value = True Then
'put your code here
this examines the property of all the checkboxes on your form,