As I was mapping out the user form I would need to allow my
users to easily enter data for a record, I came across the
"built-in" data form. It's pretty close to what I need except I
need it to be a no brainer - enter the index field data, pre-
entered fields initialize, the user enters the rest which is
validated, and never touches the spreadsheet.
But this thing is untouchable. One can programmatically visible
it by Application.ShowDataForm but that's it - can't alter
events code or properties. It is not amongst the xlDialogs (far
as I can tell). It's an arrogant little untouchable pris
taunting me into going thru the whole deal of re-creating it.

Any way to undress it and do something with it?
--
Poseur
"That's just kooky talk." --Kramer

Hi

AFAIK you can't play with the Data Form's properties but you could have a
look at
http://j-walk.com/ss/dataform/index.htm
John Walkenbach has an Enhanced Data Form as a downloadable add-in - check
out it's features / functions & other details at the web site

Cheers
JulieD


"Poseur" wrote in message
...
As I was mapping out the user form I would need to allow my
users to easily enter data for a record, I came across the
"built-in" data form. It's pretty close to what I need except I
need it to be a no brainer - enter the index field data, pre-
entered fields initialize, the user enters the rest which is
validated, and never touches the spreadsheet.
But this thing is untouchable. One can programmatically visible
it by Application.ShowDataForm but that's it - can't alter
events code or properties. It is not amongst the xlDialogs (far
as I can tell). It's an arrogant little untouchable pris
taunting me into going thru the whole deal of re-creating it.

Any way to undress it and do something with it?
--
Poseur
"That's just kooky talk." --Kramer

"JulieD" wrote in
:

Hi

AFAIK you can't play with the Data Form's properties but
you could have a look at
http://j-walk.com/ss/dataform/index.htm
John Walkenbach has an Enhanced Data Form as a downloadable
add-in

That's it. Thanks!

--
Poseur
"That's just kooky talk." --Kramer

i'm glad & thanks for the feedback
"Poseur" wrote in message
...
"JulieD" wrote in
:

Hi

AFAIK you can't play with the Data Form's properties but
you could have a look at
http://j-walk.com/ss/dataform/index.htm
John Walkenbach has an Enhanced Data Form as a downloadable
add-in

That's it. Thanks!

--
Poseur
"That's just kooky talk." --Kramer