Passing variables from module to userform

  • Thread starter Thread starter donovanm
  • Start date Start date
D

donovanm

Hi There!

Is there a different way of Passing variables from module to userform
without declaring Public Variables all the time?

I always thought that declaring Public Variables is ill-advised!?

thanks,

Matt
 
Donovan,

You could have a non-visible textbox on the form, and load that

Load Userform1
Userform1.Textbox.Text = "abc"

then access it in the activate code or other event code.

PS Public variables have their uses, just don't over-do them.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform and variables 1
Declaring variables in Module vs. Public 5
Transfer variable to user Form 2
Using variables across userforms 3
UserForm Pointers & Class Modules 3
STATIC VARIABLE NOT AVAILABLE IN ANOTHER MODULE 2
How to populate Label1.Caption with a variable's value 3
Declare and Set Public variables 2

Back
Top