ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Form (https://www.excelbanter.com/excel-discussion-misc-queries/197479-data-form.html)

HERNAN

Data Form
 
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

Data Form
 
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...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

Hernan wrote:

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

HERNAN

Data Form
 
Hi Dave,

Ok. Thank you for those links.

Hernan.

"Dave Peterson" wrote:

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...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

Hernan wrote:

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


Gord Dibben

Data Form
 
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

On Mon, 4 Aug 2008 11:29:01 -0700, Hernan
wrote:

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



Gord Dibben

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

See Dave's post<g


On Mon, 04 Aug 2008 13:52:48 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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

On Mon, 4 Aug 2008 11:29:01 -0700, Hernan
wrote:

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




All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com