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

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

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

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

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