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:

Global wsdata$, wsinvoice$

Private Sub NextBut_Click()
wsdata = ComboBox1.Value & "_DATA"
wsinvoice = ComboBox1.Value & "_DATA"

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