View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kent McPherson Kent McPherson is offline
external usenet poster
 
Posts: 15
Default Checkbox control on userform

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?