Sharing Variables Between User Forms
I have been informed that if I want to use the same variable in 2 different forms (so that I can set the value with one form but include it in a string created by a different form, that I can do so by declaring the variable in a module. How do I get at that variable then from within the userform? Do I need to reference the module some how?
Re: Sharing Variables Between User Forms
declare the variable as public in the module, then just treat it as a normal variable. It will pass the variable from form to form itself, I believe.
Re: Sharing Variables Between User Forms