Hi Debra,

Thank you thank you thank you,
I shall read through this site tonight when I have time.

SLO


Debra Dalgleish wrote in
:

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