View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David G[_4_] David G[_4_] is offline
external usenet poster
 
Posts: 23
Default Check Box Status

On Apr 18, 4:02 pm, Lee wrote:
This is a sample of the code I have to open the form, but it doesn't open
with the check boxes checked. The sheets are visible.

Private Sub OpenForm_Click()
DispHide_Frm.Show
If Sheet4.Visible = True Then Tsk_ChkBox = True
If Sheet21.Visible = True Then ResComb_Chkbox = True
End Sub


Hello Lee,

I'm not sure about this, but isn't it necessary to specify the
checkboxes as DispHide_Frm.Tsk_ChkBox and DispHide_Frm.ResComb_Chkbox
instead of just Tsk_ChkBox and ResComb_Chkbox?
Also, it may be helpful to run the debugger to see which step gives
you the unexpected result.

David