Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to pass data between forms?
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to pass data between forms?
Declare a public variable in a standard code module, simplest way.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "fedude" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to pass data between forms?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to pass data between forms?
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to pass data between forms?
Thank You.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pass value to excel userform - is there a constructor? how to pass | Excel Programming | |||
pass data between workbooks | Excel Programming | |||
How to pass data from UserForm to spreadsheet | Excel Programming | |||
Pass Data from List Boxes in Userform | Excel Programming | |||
Using Multiple User Forms to pass info from one to the other | Excel Programming |