Userform control

  • Thread starter Thread starter ZMore
  • Start date Start date
Z

ZMore

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
 
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)
 
Back
Top