Saving text in a user form

[Peter100]

I must be missing the obvious, But.

I have a user form with a text box for the user to enter notes. How do I make it save those notes entered as each time the user form is activated the text box is empty

 

[bandit_1981]

Where do you want to save the text to. Global Variable, Text file, array, database, etc?

 

[Peter100]

Hi

I don't know !! I just wanted a simple note screen for the user to enter some notes they could recall next time they open the workbook.

Your advice would be appreciated as to how I can achieve this

 

[Norie]

Peter

How are you opening/closing the userform?

Is the textbox linked to any cell on the worksheet?

 

[Peter100]

ADVERTISEMENT

Hi

The user form is opened by a command button on another user form.

there is no cell linking

 

[Legacy 98055]

Here is one way using a workbook name. Replace "TextBox1" in the code with the name of your textbox control...

Private Sub UserForm_Initialize()
    On Error Resume Next
    TextBox1.Text = [SaveTextBoxText]
End Sub

Private Sub UserForm_Terminate()
    Names.Add "SaveTextBoxText", TextBox1.Text
    ThisWorkbook.Save
End Sub

Tom

 

[Peter100]

ADVERTISEMENT

Not quite sure what you mean by
"Replace "TextBox1" in the code with the name of your textbox control...

What is my text box control ?

 

[Norie]

It's the textbox (control) on the userform.

 

[Peter100]

Sorry, I see what you meant. my control was by default textbox1 and it confused.
Where does it save the text to ?

That works a treat.

Many thanks

 

[Peter100]

Hi

I now see it saves it in as a saved name within Excel. What would be the limitations to the amount of text saved.