Store data input from textbox and store it in cell after push on button

[Bandito1]

Hello all,

I have this userform (M_Returns) that contains the label lblextra.
If it's pressed userform 1 shows with 1 big textbox txtextra

I would like that the user puts data in the textbox txtextra
After that he/she can close the Userform1 (with button) and returns to the original userform (M_Returns).

There he/she presses a button and all is stored.

How can i make it like that the data in userform1 txtExtra is stored till the button on Userform M_Returns is pressed?

 

[Micron]

Don't, otherwise you're just complicating it unnecessarily. Put it in the cell when user clicks a button on userform1, or just when they close it. Probably should test that 2nd form textbox isn't empty at that time.

 

[Bandito1]

Well im afraid that won't work.

Im using this multipage that got 5 pages.

On each page one problem can be filled in.

After all problems are filled in (sometimes 1 sometimes 3..) the person presses a button to store the problem.

So that's why it needs to be "remembered"

 

[Skyybot]

Create an Array for the Text values to be stored until needed.