ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Saving User Selections made on a Form (https://www.excelbanter.com/excel-programming/318051-saving-user-selections-made-form.html)

DMS

Saving User Selections made on a Form
 
All,

I have created a series of forms that are set up much like a wizard. This
form is used on a regular basis. On the forms the user is forced to make
several selections. Is there a way to create a template or a map of some
sort that saves the users selections so that the next time the user opens the
form, their selections are already made for them.

If this is possible, could the user have more than one map/template?

Thanks in advance.

Dave Peterson[_5_]

Saving User Selections made on a Form
 
I think I'd use another worksheet (hidden).

If your userform is in an addin and you want to retain those values, remember to
save that addin in your code.


DMS wrote:

All,

I have created a series of forms that are set up much like a wizard. This
form is used on a regular basis. On the forms the user is forced to make
several selections. Is there a way to create a template or a map of some
sort that saves the users selections so that the next time the user opens the
form, their selections are already made for them.

If this is possible, could the user have more than one map/template?

Thanks in advance.


--

Dave Peterson


All times are GMT +1. The time now is 06:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com