Hi,
I would like to know if, when using the enhanced data
entry form, I can still limit the acceptable entries from
my defined range set up as drop down in the form?
It seems that the use of the form allows data to be input
that might not otherwise be allowed if the form is not
active (through data validation messaging).
Is there a formula I can put in under Settings Custom
perhaps?

TIA

Please help.

Hi
AFAIK not possible to use Data Validation and this form together. You'll
have to create your won userform for this

--
Regards
Frank Kabel
Frankfurt, Germany

Bobby wrote:
Hi,
I would like to know if, when using the enhanced data
entry form, I can still limit the acceptable entries from
my defined range set up as drop down in the form?
It seems that the use of the form allows data to be input
that might not otherwise be allowed if the form is not
active (through data validation messaging).
Is there a formula I can put in under Settings Custom
perhaps?

TIA

Please help.

Hi Bobby

one way that i deal with this (although i'm not using John's EDF) is to have
a check data button on the toolbar - which runs a (recorded macro) - which
displays the formula auditing toolbar (under the tools menu) and circles any
data not matching the validation that i've set up on the columns.

Cheers
JulieD


"Frank Kabel" wrote in message
...
Hi
AFAIK not possible to use Data Validation and this form together. You'll
have to create your won userform for this

--
Regards
Frank Kabel
Frankfurt, Germany

Bobby wrote:
Hi,
I would like to know if, when using the enhanced data
entry form, I can still limit the acceptable entries from
my defined range set up as drop down in the form?
It seems that the use of the form allows data to be input
that might not otherwise be allowed if the form is not
active (through data validation messaging).
Is there a formula I can put in under Settings Custom
perhaps?

TIA

Please help.