View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Checkbox control on userform

I assume the code is in the userform? If it is then it might be that
hiding the worksheet if the checkbox is not set...... try.......

If UserForm1.CheckBox1.Value = True Then
Worksheets("Sheet1").Visible = True
Else
Worksheets("Sheet1").Visible = False
End If

--
Cheers
Nigel



"Kent McPherson" wrote in message
...
I have a userform with several checkbox controls on it. The intent is for
the user to check which worksheets in the workbook should be visible. I
have a button on the userform that is intended to execute code that reads
the current status of each checkbox control and then make the appropriate
worksheets visible. A piece of that code looks like:

If userform1.checkbox1.Value = True Then
Worksheets("Sheet1").Visible = True
Endif

But I don't seem to be reading the value of the checkbox. Is it not

enough
to use the userform1.checkbox1.Value in a statement?