Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
DMS DMS is offline
external usenet poster
 
Posts: 9
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,758
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can a form made in Excel 2002 be converted into a fillable form? Paraclete Excel Discussion (Misc queries) 1 February 20th 07 09:20 PM
Trouble with saving user input in an Excel Form. University of Maine student Excel Discussion (Misc queries) 0 March 14th 06 07:31 PM
user form properties not saving amescha Excel Programming 3 October 27th 04 09:03 PM
Efficient User Form vba coding for saving to worksheet Cheryl Excel Programming 1 July 23rd 04 02:07 PM
how can a user form be made that can find show and edit info for inventory robbie Excel Programming 2 January 18th 04 06:18 AM


All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"