How do I save the contents of a userform, say as text, then how do I add the
button to browse and reload the saved file.
How do I save the contents of a userform, say as text, then how do I add the
button to browse and reload the saved file.
It is easier to use a hidden excel sheet in the book that contains the
userform. I have a form with 1 textbox, 2 checkboxes, a Close button and
a Reload button. There is a sheet in the book called FromData and the
sheets visible property is set to xlVeryHidden.
When the user clicks close the forms settings are saved to the FormData
sheet. Next time the form is loaded if the user clicks Reload the
settings are returned to the form:
Private Sub cmdClose_Click()
With Sheets("FormData")
.Range("A1").Value = Me.TextBox1.Text
.Range("A2").Value = Me.CheckBox1.Value
.Range("A3").Value = Me.CheckBox2.Value
End With
Unload Me
End Sub
Private Sub cmdReload_Click()
With Sheets("FormData")
Me.TextBox1.Text = .Range("A1").Value
Me.CheckBox1.Value = .Range("A2").Value
Me.CheckBox2.Value = .Range("A3").Value
End With
End Sub
Hope this helps
Rowan
bennyob wrote:
> How do I save the contents of a userform, say as text, then how do I add the
> button to browse and reload the saved file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks