#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Form Leanne Excel Discussion (Misc queries) 10 April 22nd 08 08:41 PM
Create a form in excel so I can enter data using DataForm Lynn Excel Discussion (Misc queries) 2 February 14th 07 06:35 PM
how to get a data form to fill you own exel sheet (was data-form erik van buijtenen Excel Worksheet Functions 2 May 30th 06 05:31 PM
format data displayed on Excel data entry form Bob, too Setting up and Configuration of Excel 0 May 19th 05 08:26 PM
have 3 worksheets, 1 is a form, the other 2 data for the form-wan. bken Excel Worksheet Functions 0 January 12th 05 09:15 PM


All times are GMT +1. The time now is 02:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"