How to keep the Checkboxes selected by the user unchanged even after closing the userform

[Guest]

Hi All,

I need a solution to keep this data in the checkboxes unchanged even after the userfrom is closed.
Basically the user from is displayed by selecting a command button of type form control on a spreadsheet.

Please put some light on this.

Thanks
Harinath

 

[Ron de Bruin]

Hi Harinath

You can hide the form instead of closing it

 

[JE McGimpsey]

Either don't close the Userform (use .Hide, instead), or save the
checkbox values on a (possibly hidden) worksheet, and read them back in
when the Userform is reopened.

 

[Bob Phillips]

Harinath,

You probably have the statement

Unload Me

or

Unload Userform1

somewhere in the code. This has the effect of removing the visual form, but
also clearing it from memory, so when you display it again, all controls are
re-initialised.

Change the code to

Me.Hide

which will remove the visual form, but retain it in memory.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

Can you send some example on this

Thank
Harinath

 

[Bob Phillips]

It would be better for you to post your code and we can comment on it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)