Carry variables from one form to another in V

Closed
nag - Feb 21, 2010 at 06:27 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 21, 2010 at 07:43 AM
Hello,
I'hv created 4 forms where the data of an application form is filled.I want the data to be submitted only when all 3 forms are filled.The data enters the excel sheet at row 5 since first 4 rows of my sheet are header rows.I hv a variable that will calculate the row numbe to start entring the data each time form is run.I want this variable and its value to be carried till the 4th form and all data to be entered in same row till Submit button is clicked.How do i do this in VBA?Pls do reply me with the code.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 21, 2010 at 07:43 AM
declare your variable at the top of the module as public.

public lLastRow as long

This will make lLastRow available to all modules in the application
0