Hello,
I was wondering if there is a good way to effectively be able to use variables in userforms, or allow them to manipulate them, without declaring them public.
I have a sub, which opens a userform, and want to be able to use variables used within the sub. To the best of my knowledge I cannot pass a variable to a userform the way you can from one sub to another.
The way I have been doing this has been simply to declare variables as public variables, but those seem to be not preferred by other programmers and I am looking for a better alternative.
Thanks,
googlebot
Bookmarks