Userform (displaying another userform) and output data

[cmerrick]

Hi,

I have a user form (Userform1) that adds a row into a table, one of the options on Userform1 displays a new user form (Userform2) allowing the user to key in some dates.

Now obviously, the dates that have just been keyed in cannot be transferred to the 'new row' in the table because Userform1 has not yet been completed so the 'new row' has not been created.

Is there a way to 'store' the dates that have been keyed onto Userform2 and then recall them into the work sheet once Userform1 has been completed?

Regards

 

[AKR22]

Re: Help with needed with userform (displaying another userform) and ouput data

Yes, a simple way is to store the date in a public variable. You set up this public variable in a module.

Just create a new module and define all the variables that go between userforms there. Then modify and get the variables in the userform code as needed.

Cheers.