Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question regarding UserForm | Excel Discussion (Misc queries) | |||
Userform Question | Excel Discussion (Misc queries) | |||
UserForm Question | Excel Programming | |||
UserForm Question | Excel Programming | |||
Userform question | Excel Programming |