Data Form

[Hernan]

Hello,

Is there a way to look at the code of the form created by choosing from the
menu Data/Form?

Thanks in advanced.

Hernan

 

[Dave Peterson]

Nope. (Well, unless you got a job at MS in the Excel group.)

But...

You could look at John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

The source code is available for a small fee ($20 USA, IIRC). So you can modify
it as much as you want.

And if you want to design your own:

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp
Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp

 

[Hernan]

Hi Dave,

Ok. Thank you for those links.

Hernan.

 

[Gord Dibben]

No

What are you looking for?

Maybe John Walkenbach's Enhanced Data Form add-in would be close to what you
want.

The VBA Project password can be purchased for a small fee.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

And the link to John's site is.................

See Dave's post<g>