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:
![]()
Please Login or Register to view this content.
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
Bookmarks