Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform control
Do a Userform1.Hide rather than a Unload Userform1. The userform is then
maintained in memory, just not visible. The settings should then be saved, as long as you don't have any Userform_Activate code that changes them. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "ZMore " wrote in message ... Userform with checkbox: Currently trying to find a way to cause userform settings to be saved on close. When form is re-opened, need same settings to show in form. Trying to do this with UserForm_Initialize and UserForm_Terminate. Have searched the forum with no luck. Your help is greatly appreciated. --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform control | Excel Programming | |||
userform frame control | Excel Programming | |||
Updating .tag in Userform Control in VBA | Excel Programming | |||
UserForm Control | Excel Programming | |||
UserForm Control | Excel Programming |