Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm remembering Settings
Is it possible for a checkbox on a userform to be saved in the last
setting that the user left it in, when the user closes and saves the workbook - without using any worksheet cells. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm remembering Settings
I am no MVP, but I'd say no. I would create
hidden "settings" worksheet and store user settings there. -----Original Message----- Is it possible for a checkbox on a userform to be saved in the last setting that the user left it in, when the user closes and saves the workbook - without using any worksheet cells. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm remembering Settings
Jason,
The setting would have to be stored somewhere, such as in a worksheet cell, a defined name, or in the system registry. You can use SaveSetting to store the check box state in the registry when the form is closed, and then use GetSetting to retrieve the setting when the form is initialized. For example, Private Sub UserForm_Initialize() Me.CheckBox1.Value = CBool(GetSetting("AppName", "Setup", _ "CheckBox1State", "False")) End Sub Private Sub UserForm_Terminate() SaveSetting "AppName", "Setup", "CheckBox1State", _ Format(Me.CheckBox1.Value) End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "jason" wrote in message om... Is it possible for a checkbox on a userform to be saved in the last setting that the user left it in, when the user closes and saves the workbook - without using any worksheet cells. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm remembering Settings
you'll have to use the registry using SaveSettings/GetSettings or else you can easily store an array of values in a hidden name object Sub Store() Dim v v = Array(1, "john", True) ActiveWorkbook.Names.Add "myhiddensettings", v, False End Sub keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool (jason) wrote: Is it possible for a checkbox on a userform to be saved in the last setting that the user left it in, when the user closes and saves the workbook - without using any worksheet cells. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm remembering Settings
Cheers KIC
like your style - hidden named range J keepitcool wrote in message . .. you'll have to use the registry using SaveSettings/GetSettings or else you can easily store an array of values in a hidden name object Sub Store() Dim v v = Array(1, "john", True) ActiveWorkbook.Names.Add "myhiddensettings", v, False End Sub keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool (jason) wrote: Is it possible for a checkbox on a userform to be saved in the last setting that the user left it in, when the user closes and saves the workbook - without using any worksheet cells. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm remembering Settings
KIC
If I use this code: Sub Store() Dim v v = Array(True, False, True) ActiveWorkbook.Names.Add "XXX", v, False End Sub then what code do I use to extract say the second entry in the array (the False entry) ? Jason keepitcool wrote in message . .. you'll have to use the registry using SaveSettings/GetSettings or else you can easily store an array of values in a hidden name object Sub Store() Dim v v = Array(1, "john", True) ActiveWorkbook.Names.Add "myhiddensettings", v, False End Sub keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool (jason) wrote: Is it possible for a checkbox on a userform to be saved in the last setting that the user left it in, when the user closes and saves the workbook - without using any worksheet cells. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm remembering Settings
Jason, try:
Sub ReStore() Dim v v = Evaluate(ActiveWorkbook.Names("XXX").RefersTo) msgbox "second entry is:" & v(2) End Sub pls note that Evaluate returns a 1based array! keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool (jason) wrote: KIC If I use this code: Sub Store() Dim v v = Array(True, False, True) ActiveWorkbook.Names.Add "XXX", v, False End Sub then what code do I use to extract say the second entry in the array (the False entry) ? Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remembering lookups | Excel Worksheet Functions | |||
Remembering position in shared workbook | Excel Discussion (Misc queries) | |||
Remembering a value moving from one sheet to another | Excel Discussion (Misc queries) | |||
Remembering Data Values. | New Users to Excel | |||
Easy one: Remembering previous sheet name | Excel Programming |