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

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