Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multipage form
I have a 5 page multipage form and I want to in some cases hide certain pages
and some cases make all of the controls on a given page read only. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
multipage form
the code below is a rough guide. I have put four buttons onto a form with a
multipage object with 5 tabs ( 0 - 4 ) tab 2 ( the third tab) has an edit box as its only control, ie item 0 in the controls collection The buttons hide & show the third tab, and enable/disable the editbox Private Sub cmdDisableEditBox_Click() With MultiPage1.Pages(2).Controls .Item(0).Enabled = False End With End Sub Private Sub cmdEnableEditBox_Click() With MultiPage1.Pages(2).Controls .Item(0).Enabled = True End With End Sub Private Sub cmdHideTab3_Click() MultiPage1.Pages(2).Visible = False End Sub Private Sub cmdShowTab3_Click() MultiPage1.Pages(2).Visible = True End Sub HTH Patrick Molloy Microsoft Excel MVP "Sandy" wrote: I have a 5 page multipage form and I want to in some cases hide certain pages and some cases make all of the controls on a given page read only. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MultiPage Form Question | Excel Discussion (Misc queries) | |||
Duplicate Values on Multipage form | Excel Programming | |||
Multipage & Spinbutton controls on a form | Excel Programming | |||
Multipage Object on User Form | Excel Programming | |||
Can I set a page of a Multipage form to active? | Excel Programming |