Hello,

I haven't been able to find out how is it that I can look at the code from
the form that is created when selecting the first cell in which my list
resides.

Is it possible?

I do not know how to recreate it through VBE. I will be able to learn from
it, and also work a little less, since I have my sheet set up with what I
want to do, but I want to preserve everything protected and through a data
entry form that I can create.

TIA.

Hernan.

You can't see the code that MS uses for Data|Form (xl2003 menus).

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

Hernan wrote:

Hello,

I haven't been able to find out how is it that I can look at the code from
the form that is created when selecting the first cell in which my list
resides.

Is it possible?

I do not know how to recreate it through VBE. I will be able to learn from
it, and also work a little less, since I have my sheet set up with what I
want to do, but I want to preserve everything protected and through a data
entry form that I can create.

TIA.

Hernan.

--

Dave Peterson

You cannot view the code behind the DataForm, however, John Walkenbach has
created an Enhanced Data Form. For $15 you can buy the password to view the
code. The form itself is free to use.
http://spreadsheetpage.com/index.php/dataform/home

Mike F
"Hernan" wrote in message
...
Hello,

I haven't been able to find out how is it that I can look at the code from
the form that is created when selecting the first cell in which my list
resides.

Is it possible?

I do not know how to recreate it through VBE. I will be able to learn from
it, and also work a little less, since I have my sheet set up with what I
want to do, but I want to preserve everything protected and through a data
entry form that I can create.

TIA.

Hernan.

Thank you Dave and Mike.

Hernan

"Dave Peterson" wrote:

You can't see the code that MS uses for Data|Form (xl2003 menus).

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

Hernan wrote:

Hello,

I haven't been able to find out how is it that I can look at the code from
the form that is created when selecting the first cell in which my list
resides.

Is it possible?

I do not know how to recreate it through VBE. I will be able to learn from
it, and also work a little less, since I have my sheet set up with what I
want to do, but I want to preserve everything protected and through a data
entry form that I can create.

TIA.

Hernan.

--

Dave Peterson