| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you save a form created with the data form wizard
I am trying to create a data entry form in Excel 2007. The data form wizard
provides much but not all that I want on my form. Is it possible to start by creating a data entry form using the wizard then save that code and edit/add to it in VBE? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do you save a form created with the data form wizard
Nope. You can show the builtin form, but you can't modify it.
John Walkenbach has an enhanced data form: http://j-walk.com/ss/dataform/index.htm And the source code is available for a small fee ($20 USA, IIRC). And if that's not sufficient, then maybe you could design your own input userform. Debra Dalgleish shares some tips: http://contextures.com/xlUserForm01.html FrankC wrote: I am trying to create a data entry form in Excel 2007. The data form wizard provides much but not all that I want on my form. Is it possible to start by creating a data entry form using the wizard then save that code and edit/add to it in VBE? Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula (off form) that completes form data based on a result | Excel Worksheet Functions | |||
| Built-In Data Form Doesn't Save Edits | Excel Discussion (Misc queries) | |||
| excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
| I created a form on excel. want to edit the form without printing | Excel Discussion (Misc queries) | |||
| Save data in template from a form. Please Help! | Excel Programming | |||
Linear Mode
