Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving Userform as Gif | Excel Programming | |||
Reloading values in optionbuttons or checkboxes | Excel Programming | |||
userform txt box contents | Excel Discussion (Misc queries) | |||
reloading a userform query | Excel Programming | |||
reloading arrays | Excel Programming |