Thread
:
Hide a page in a multi page userform
View Single Post
#
2
Posted to microsoft.public.excel.programming
keepITcool
external usenet poster
Posts: 2,253
Hide a page in a multi page userform
myMultipage.Pages(0).visible=false
keepITcool
< email : keepitcool chello nl (with @ and .)
< homepage:
http://members.chello.nl/keepitcool
(Ian Mangelsdorf) wrote:
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
Reply With Quote
keepITcool
View Public Profile
Find all posts by keepITcool