Enable/disable page on multipage

[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

 

[Vasant Nanavati]

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

 

[Phillip Topping]

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

 

[Vasant Nanavati]

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

--

Vasant


Thanks again