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

--

Vasant



"Phillip Topping" wrote in message
...
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

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

-----Original Message-----
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

--

Vasant



"Phillip Topping"
wrote in message
...
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



.

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

--

Vasant


"Phillip Topping" wrote in message
...
Thanks again :)