Is it possible to have a user form retain data for two of the combo boxes for the entry?

[Juli]

The user form populates several different sheets in the workbook. Two of the boxes (one text and one combo) will be the same for all of the days entry (location and date). All of the other data will be different. I would like to know if it is possible for the data in those two boxes to remain so the user does not have to retype or select them for each person he is entering.
Juli

[abousetta]

Maybe something like:

Please Login or Register  to view this content.

[Juli]

abousetta,
Thank you for the fast response. I can see that I was not at all clear in my post. Your code works great if the data doesn't ever change (which is how my post sounded) but what I was trying to say is that when the user opens the workbook to enter data for that entry session the date and location will be the same. They will have to enter the data once, but then for all the subsequent forms they complete during that session the date and location will be the same. I was trying to come up with a way to avoid having them have to enter that information over and over for each entry since it is the same for the whole entry session.
Juli

[abousetta]

Hi Juli,

Please Login or Register  to view this content.

This will keep the data until new data is written in these two fields.

If you want a certain data to allows be presented you can set it up as a constant.

If you want it to remain even if the user closes the userform then use

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

If you want it to remain between sessions (after you close the workbook) then save the input in a hidden sheet.

Hope this helps.

abousetta

[Juli]

Abousetta,
That works perfectly. Thank You very much for the help.
Juli

[abousetta]

Thanks for the feedback.

Glad it all worked out.

Good luck.

abousetta