View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian Mangelsdorf Ian Mangelsdorf is offline
external usenet poster
 
Posts: 17
Default Hide a page in a multi page userform

I have set up a multi page user form and wish to have the user select
a range of tests per sample (using check boxes). I would like to have
the corresponding page not visble unless the checkbox. value=true

I have used this code

Private Sub Chk_ff_Click()

If Chk_ff.Value = True Then
SCAL_Data.pg_ff.visable = True
Else: pg_ff.visable = False
End If
End Sub

with pg_ff being the name I have given the secified page and SCAL_data
being the name of the form.

I am getting an object required error.

Any hints would be great

Cheers

ian