Need button to load the next UserForm

[zamirkaya]

I'd like a button on a userform to load the next userform from the one I'm on. So what I mean is, I have UserForm1 open and I have a "password" UserForm that appears when a button combination is used, that's UserForm17. I'd like UserForm17 to load the next UserForm from whichever UserForm I'm on.

Can anyone help?

[Norie]

To load and display a userform use formname.Show, to unload the current form use Unload Me.

For example.

Please Login or Register  to view this content.

[zamirkaya]

Sorry Norie, I don't think I made it clear enough because I'm not quite sure how to word it. I'd like the button combination which loads UserForm17 to move onto the next UserForm on which I load it. So if I loaded UserForm17 up whilst I was on UserForm5, I'd like it to move onto UserForm6.

[Norie]

The code I posted is just really an example, if you want to load UserForm6 change UserForm1.Show to UserForm6.Show.

PS What do you mean by 'button combination'?

[zamirkaya]

It's a macro that basically opens UserForm17 when I press CTRL + SHIFT + J

[zamirkaya]

I have this code which closes a UserForm:

Please Login or Register  to view this content.

[Norie]

That code closes all open userforms.

[zamirkaya]

Is there anything similar which would open the next UserForm in the row? So open UserForm2 if I used the code on UserForm1 any so on?

[Norie]

Are the userforms named sequentially? ie UserForm1, UserForm2 etc.

[zamirkaya]

Yes, and it goes from 1 to 15.

[Norie]

Perhaps something like this.

Please Login or Register  to view this content.

[zamirkaya]

It just comes back with "Compile error: Invalid use of Me keyword".

[Norie]

I thought this code was for a button on a userform?

[zamirkaya]

Would you like me to attach the file to take a look?

[zamirkaya]

Here you go.

[zamirkaya]

Hellooooo?