Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I e-mail 1 page of a multi page workbook | Excel Discussion (Misc queries) | |||
Get header only on first page of multi page excel file | Excel Discussion (Misc queries) | |||
I want to print multi pages on one page. | Excel Discussion (Misc queries) | |||
multi page copy | Excel Discussion (Misc queries) | |||
multi-page control questions... | Excel Programming |