LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 154
Default Userform Question - is this possible?

I would like to show a userform, force certain textboxes
to be filled, then permit user to "Save".
"Save" would:
1. preserve the values in those textboxes.
2. export the form (with code behind the form) and
those textbox values, to a new workbook.
3. User would be able to name the new workbook
and (single) sheet, and choose the Save Folder.
4. Edit some of the code behind the form in this new
workbook to limit some of the options they had in
the original form.
5. User would then navigate to the saved book, open it,
and the saved form would be presented.

Does this seem feasible, please?

As regards 4.: the original form will be called via an addin, so perhaps
the new form's code could be stored there, and then copied into the new
workbook behind that form? If that makes sense.

Help/examples most welcome please.

Regards.




 
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
Question regarding UserForm TotallyConfused Excel Discussion (Misc queries) 0 September 3rd 09 09:38 PM
Userform Question Greg B Excel Discussion (Misc queries) 3 March 10th 05 10:46 AM
UserForm Question jer Excel Programming 4 January 13th 05 11:19 PM
UserForm Question bforster1[_25_] Excel Programming 1 November 6th 04 01:21 PM
Userform question David Goodall Excel Programming 5 May 12th 04 10:18 AM


All times are GMT +1. The time now is 12:16 AM.

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"