Persistent Data in a Combo Box

I am a newbie so please bear with me. I have an Excel workbook in which I
have enabled several forms. The users sometimes close a form and then
re-open it to pick up where they left off. How do I set the text and combo
boxes to keep the data in them persistent so long as the workbook has not
been closed? Is this a Property of the form fields or do I need to write
sppecific code? Thanks...

What do you mean by "enabled several forms?"

Are these UserForms? If so, hide the forms rather than unloading them when
the users try to close them.

--

Vasant

"The Hawk" <[email protected]> wrote in message
news:[email protected]...
> I am a newbie so please bear with me. I have an Excel workbook in which I
> have enabled several forms. The users sometimes close a form and then
> re-open it to pick up where they left off. How do I set the text and
combo
> boxes to keep the data in them persistent so long as the workbook has not
> been closed? Is this a Property of the form fields or do I need to write
> sppecific code? Thanks...

Yes, they are user forms and yes I was closing them. Changed to hide and
just what I wanted. Thanks...

"Vasant Nanavati" wrote:

> What do you mean by "enabled several forms?"
>
> Are these UserForms? If so, hide the forms rather than unloading them when
> the users try to close them.
>
> --
>
> Vasant
>
> "The Hawk" <[email protected]> wrote in message
> news:[email protected]...
> > I am a newbie so please bear with me. I have an Excel workbook in which I
> > have enabled several forms. The users sometimes close a form and then
> > re-open it to pick up where they left off. How do I set the text and
> combo
> > boxes to keep the data in them persistent so long as the workbook has not
> > been closed? Is this a Property of the form fields or do I need to write
> > sppecific code? Thanks...
>
>
>

When the userform is closed by whatever method, hide it do not unload it.

Take a look at the QueryClose method to give you extra control over the
close.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"The Hawk" <[email protected]> wrote in message
news:[email protected]...
> I am a newbie so please bear with me. I have an Excel workbook in which I
> have enabled several forms. The users sometimes close a form and then
> re-open it to pick up where they left off. How do I set the text and
combo
> boxes to keep the data in them persistent so long as the workbook has not
> been closed? Is this a Property of the form fields or do I need to write
> sppecific code? Thanks...