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
Here is one way using a workbook name. Replace "TextBox1" in the code with the name of your textbox control...
Code:
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
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.