UserForm Help please

[GiraffetheGeek]

Hi there all,

I have just ventured into creating and using UserForms.

I have a userform that has 80 textboxes on it that I want users to enter different information into.

The userform is called by a button on a sheet that has the code

Private Sub Btn_WorkBridge_Click()
    Schedule_Workbridge.Show
End Sub

I currently do not have any code in the userform_initialize function as at present I do not think I need it.

I have one button called "Close" that was the code

Private Sub CommandButton1_Click()
    Unload UserForm_WB
End Sub

What I want to happen is for a user to enter data into the relevant text fields then be able to close the user form. When the come back at a later time to open the userform again I want the data they entered previously to still be there.

Currently this does not happen and when the userform is open for subsequent times the text boxes are blank and not pre-filled.

I could work out having all the data transfered to cells on the sheet that then would be hidden and then use the initialize function to enter them all again once it is opened again but am hoping there is an easier way, maybe a "save" function somewhere that I don't know about.

As mentioned before this is my first real foray into userforms so am learning on the fly.

Cheers in advance for your help​

 

[GTO]

You do not need to save the vals at this point. Just hide the form w/o unloading:

Schedule_Workbridge.Hide

 

[GiraffetheGeek]

Cheers that clears one thing up.

Next question:
I want the user to be able to close the whole workbook if needed, and then have those values still there once the userform is opened again after the workbook open for a second or subsequent time.

Is this possible without using code to transfer all the information to the worksheet and then use code again to re-load it all back in?

 

[GTO]

Short answer is no. Technically, you can write to the registry, write to a textfile, etc, but saving to a hidden sheet seems easiest IMO.

 

[GiraffetheGeek]

After reading my question again I may have confused the issue.

What I wanted to know was, is it possible to have the information the user enters into the userforms text boxes saved somehow so that it can be unloaded and then re-opened (possibily even having the workbook closed completely and reopened) and have that data still there, without having to transfer it back and forth from a worksheet?

 

[GTO]

I am afraid my answer stays the same. If the wb is closed, it ain't running and neither is any code in it. Thus, any variables' values therein (in the wb) are lost unless you write them someplace. Does that make sense?

 

[GiraffetheGeek]

Yeah it does - cheers,

Dang, now I have to write the code to transfer the data to a worksheet - oh well, such is life