Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using a userform with listboxes that the user enters data into and than
another userform that returns the calculated results. I would like to know the code to retain text that was entered in each listbox (in the registry or whatever) on the press of an action button. Here is JW's solution but I get an error improper use of Me function or something similar when I use it. 'Sub Getdefaults() ' Dim ctl As Control ' Dim Ctrltype As String ' For Each ctl In Me.Controls 'Ctrltype = TypeName(ctl) 'If Ctrltype = "Textbox" Or _ '"Combobox" Or _ '"Optionbox" Or _ '"Checkbox" Or _ '"Spinbutton" Then 'ctl.Value = GetSetting _ '(APPNAME, "Defaults", ctl.Name, ctl.Value) 'End If 'Next ctl 'End Sub 'Sub SaveDefaults() ' Dim ctl As Control ' Dim Ctrltype As String ' For Each ctl In Me.Controls 'Ctrltype = TypeName(ctl) 'If Ctrltype = "Textbox" Or _ '"Combobox" Or _ '"Optionbox" Or _ '"Checkbox" Or _ '"Spinbutton" Then 'SaveSetting APPNAME, _ '"Defaults", ctl.Name, ctl.Value 'End If 'Next ctl 'End Sub Any thoughts? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excell copy action pauses for 15 second for the smallest action | Excel Discussion (Misc queries) | |||
VBA to run every month and sorting data from userforms | Excel Discussion (Misc queries) | |||
Saving Information on Userforms | Excel Programming | |||
UserForms and Variables and Types of data | Excel Programming | |||
Userforms - Dealing with zeros and non-entry of data | Excel Programming |