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?
To load and display a userform use formname.Show, to unload the current form use Unload Me.
For example.
Unload Me UserForm1.Show
If posting code please use code tags, see here.
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.
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'?
It's a macro that basically opens UserForm17 when I press CTRL + SHIFT + J
I have this code which closes a UserForm:
Sub CloseForm() Dim i As Long, Str As String For i = VBA.UserForms.Count - 1 To 0 Step -1 Str = Str & VBA.UserForms(i).Name & vbNewLine Unload VBA.UserForms(i) Next i End Sub
That code closes all open userforms.
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?
Are the userforms named sequentially? ie UserForm1, UserForm2 etc.
Yes, and it goes from 1 to 15.
Perhaps something like this.
Dim NextForm As String NextForm = "UserForm" & (Mid(Me.Name, 9) + 1) Unload Me UserForms.Add NextForm UserForms(UserForms.Count - 1).Show
It just comes back with "Compile error: Invalid use of Me keyword".
I thought this code was for a button on a userform?
Here you go.
Would you like me to attach the file to take a look?
Hellooooo?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks