Hi
for this you'll need an event procedure. e.g. the worksheet_change
event. See:
http://www.cpearson.com/excel/events.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Brian" schrieb im Newsbeitrag
...
Here is what i have:

starting on row 9 on down to whatever row A B
C D
date of
job
Emp Name ID# PIN#
Column A is a range of dates for different side jobs that an employee
can
sign up for and work. And right now entering the proper pin# returns
the id#
of the employee, which in turn returns the employees name.
When the proper pin# is entered (proper pin is verified only when
the id#
is returned in C, otherwise C remains blank) I want a user form to
appear
confirming that the employee wants to sign up for the date which
appears in
the date of job column. Example

A B C
D
date of job emp name ID# Pin#

11/1/04 john smith 123 2468 (upon
entering this pin)

User form appears "Confirm that you want to sign up for 11/1/04"
yes button no button

if yes lock the cell that contains the pin#
if no clear the cell that contains the pin#

I am sorry if this post is short on clarity I tried my best.
Thank You
Brian