MultiPage UserForm sees runtime error 380 invalid property value

[JasonExcel]

Hi All

I am trying to get my Excel VBA UserForm to launch at page 3 on initialisation.

To accomplish this I inserted the following code into my project:-

Private Sub UserForm_Initialize()

UserForm1.MultiPage1.Value = 3

End Sub

This produced the following error 'Run Time Error '380': Could not set the value property. Invalid value property'

So I also tried:-

me.MultiPage1.Value = 3

and then

MultiPage1.Value = 3

I still got the same error. Oddly though, the following code works to launch a different tab, albeit that it isn't the tab that I need the sheet to open on:-

MultiPage1.Value = 2

There are definitely three pages on my multipage form and the (Name) showing under properties for my desired launch page is Page3

I'm sure there's an easy enough explanation for this but I just can't seem to see it...

Thank you

 

[steve the fish]

If you have three pages the values should be 0,1 and 2 not 1,2 and 3.

 

[JasonExcel]

That fixed it - my target sheet, Page3, has a value of 0. Thanks for the help