Moving from a userform to another userform

[patupatu]

Hello.

I have a userform from which I pick up some values, then I seach in a excel sheet for that value, and then I have another userform in which I want to display the data found. How do I close a form and open another. And can I send parameters to somehow conditioned how the other form would sppear?

Thank you very much

Patupatu

 

[doofusboy]

How do I close a form and open another.

Kind of depends on where you are doing this from. For example, if you want to close UserForm1 from within the code of UserForm1, you can simply use

Unload Me

If you want to close UserForm1 from a worksheet's code, you could use:

Unload UserForm1

To open another form:

UserForm2.Show

can I send parameters to somehow conditioned how the other form would sppear

You could write your own Sub that accepts parameters and have it called by Private Sub UserForm_Initialize() so that it executes when the form opens.

 

[Smitty]

If the data is related, another option might be to use a Multi-Page control and just switch pages.