Global Variables

Hey! I'm aware that this pops up seven hundred billion times a day, but I can't seem to get it working whatsoever.
My users have to use a sequence of userforms in my VBA project. In the first one, they choose some previously imported data to base the rest of the work on.
This imported data is a worksheet in the workbook, with name wsdata
Based on that, it creates a new worksheet, with name wsinvoice.
However, once I get to the next userform, wsinvoice and wsdata are cleared so they have no value. I could make it so wsinvoice is always added at the end of the workbook thus making wsinvoice always Sheets(Worksheets.Count), but that doesn't solve the wsdata.

Theoretically, I should just be able to do the following in the first userform:

Please Login or Register  to view this content.

No luck though. wsdata and wsinvoice are useless outside of userform1...halp? <3

This

Please Login or Register  to view this content.

Needs to be in a module, not a userform

And Public variables in modules are evil

XD XD XD This forum is great. You've made Lady Marmalade a happy man XD
Given that I'm now classed as being evil, I best cackle my way back to my attempt at VBA Thanks guys! :D