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?
|