There's a sample file he

http://www.contextures.com/excelfiles.html


Under 'Data Validation' look for DV0012 - Update Validation List



Stan Lo wrote:
Hi Toppers,

Thank you for your respond.

I did apply the data validation method and have been using it. In fact
I have use several data validation function on this worksheet as the
date and code of attendance will have to be verified. All work well
excet for the name list. When the user typed in a name instead of
choosing it from the drop down list, the entry will be accepted even if
it is not on the list. I have tried different settings with the
verification but to no avail. Nevertheless, I was thinking that even if
the data verification part is working, I still need the spreadsheet to
be able to accept new names and add to the existing list when it was not
found on the list, hence the reason of me asking if code should be used.

Thanks

SLO


?B?VG9wcGVycw==?= wrote in
:


Consider making the "name" entry a Data Validation entry based on your
list of names so it would not need code.

"Stan Lo" wrote:


Hi All,

I'm a newbie with Excel VBA so please beare with me. I'm developing
a daily logging spreadsheet on all the employee's attendance. This
spreadsheet comprises of 2 sheets;"incidents" and "name". First
being the logging sheet and the later contains a list of employee's
name. When a name is entered into any cells in column D in
"incident", it needs to be validated by comparing to the named range
in "name". If the name exist, then the name will be accepted as is.
Otherwise the user will have the option of re-entering the name or
add the name to the existing list in the named range under "name".

Any help is much appreciated.

Slo





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html