Previous, Next, and Home Buttons (Open and Close Userforms)

[Fromlostdays]

I've created a bunch of userforms to help me fill out an excel spreadsheet. With over 700 cells that need to be filled out, usually with yes or no answers, I have to use multiple userforms.

My question is: how do I code a Previous, Next, and Home button (on every individual form) that when pressed will both close the current userform and then open another one? I'm not even sure if it's possible, but any help would be appreciated.

Thank you,

 

[CalcSux78]

Have you tried anything like this?

Private Sub CommandButton1_Click()
Unload Me
UserForm1.Show False
End Sub

If I'm following correctly, one userform needs to have a button to close out the current form and open a different one. What I did was added the "Unload Me" line then in the next line, call the next userform.

 

[Fromlostdays]

Wow it worked! If you read this, thanks. I did try something similar yesterday, and I kept getting a runtime error. I think the only thing I did different was leave out the "False" after .show...

At any rate, I am one happy camper. Thanks again!