Userform with checkbox: Currently trying to find a way to cause userfor
settings to be saved on close. When form is re-opened, need sam
settings to show in form. Trying to do this with UserForm_Initializ
and UserForm_Terminate. Have searched the forum with no luck. Your hel
is greatly appreciated

--
Message posted from http://www.ExcelForum.com

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/