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

Hi Harinath

You can hide the form instead of closing it


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Harinath" wrote in message ...
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

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.

In article ,
"Harinath" wrote:

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.

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)

"Harinath" wrote in message
...
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

Can you send some example on this

Thank
Harinath

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)

"Bob Phillips" wrote in message
...
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)

"Harinath" wrote in message
...
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