How to export a variable from a userform to another?

[marlonsaveri]

Hi,

I created a userform to find sheets that has a specific word in its names (typed in a textbox); worksheets' numbers are stored in a vector MySheets(j)

So, I would like to open a userform with a spinbutton (or 2 buttons) to scroll through these sheets, openning it with something like:

Private Sub SpinButton1_SpinUp()
    Sheets(MySheets(SpinButton1.Value)).Select
End Sub

But, this new userform2 doesn't recognizes "MySheets(j)". So, I'd like to know how to "export" "MySheets()" from a userform to another or how to send the typed word (from useform1/textbox1) to userform2.

Thanks

[BigBas]

Try inserting a standard module into your VBA project.

In the standard module, use the following code:

Public mysheets() as variant

Does this help?