Best way to pass data between forms?
On Jun 3, 10:49*am, fedude wrote:
Do I just creat another module anyhere in the spreadsheet or is there
someplace special I need to declare these variables?
"JW" wrote:
On Jun 3, 7:46 am, fedude wrote:
I have a form (form A) that "shows" another form (form B). *Form B collects
data that I want to be available to Form A when Form B is unloaded.
In addition I want to pass data from Form A to Form B when it is
instantiated. *I assume I can set the value of hidden label when I create
form B, but this seems a little stupid. *
Any advice on how to do this?
I agree with Bob. *Declare Public variables in a standard module and
then set them as needed. *For instance, if you want textbox1 on Form B
to be populated when it opens with the value from textbox2 on Form A,
you could use:
Standard module:
Public example As String
Button on Form A that opens form B
example = Me.textbox2
Initialize event of Form B
Me.textbox1.Text = example
HTH- Hide quoted text -
- Show quoted text -
They just need to be declared at the top of a standard module. I
typically create a module for nothing but my public declerations.
|