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)
 
Back
Top