Userform; open textbox, close it and after that register it

[Bandito1]

Hello all,

See below, this is part of my userform.
I would like to store comments behind the comboboxes (the blue "+").

When the "+" is pressed a new userform is opened with a textbox
I would like that a user is able to type his comment in the textbox, close it and then continues on the userform that is shown below.
The user can reopen the comments by pressing the "+" again.

when he is done and presses add observation the comments are also stored.

I know how to store data from textbox on the worksheet but i have no idea how to "temporary" store the value in a textbox.
Someone gave the tip to use array but i don't know where to start

 

[frabulator]

You can have a public string declared.
Above your code, after the imports (if you have any) and before you run into any subs, put this

Public TempString as String

Now anywhere in your code you can reference that. I would recommend you put it in a module instead of a userform because you can call a module at any time. To call from a userform you will need to open the userform to call it.

Example:

Dim ThisString as String
ThisString = Userform1.TempString

from a module you just call it like any other string.

 

[dmt32]

Hi,
Have a look at using the Controls Tag Property :Tag property

which can hold your comments whilst your form remains in memory.

Dave