Enable/disable page on multipage

  • Thread starter Thread starter Phillip Topping
  • Start date Start date
P

Phillip Topping

I have a user form with a multipage on it.

Most of the time all the pages are enabled but there will
be some occasions that when the form loads, I will need to
disable all but one of the pages. I know I can disable
them just by changing their enabled/disabled status in the
form design but this does not help me.

I need to be able to change their status dependent on the
results of cell contents using If..Then etc.

I cannot find any way in VB to help me do this.

Any suggestions would be greatly appreciated.
TIA
Phillip
 
Something like:

Private Sub UserForm_Initialize()
If Range("A1") = "X" Then
MultiPage1.Pages(1).Enabled = True
Else
MultiPage1.Pages(1).Enabled = False
End If
End Sub
 
Hi Vasant,
Thanks for your help, this is the line of code that I kept
getting wrong but you have solved it for me.

MultiPage1.Pages(1).Enabled = True

(or false as the case may be)

I had all the other logic sorted, just kept getting the
syntax of that line wrong.

Thanks again :)
Phillip
 
Glad to help ... I can't tell you how often I overlook obvious solutions
that are staring me in the face!

--

Vasant


Thanks again :)
 
Back
Top