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

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

Try this, with Worksheet_Change macro:-

Private Sub Worksheet_Change(ByVal Target As Range)
If Not (Target.Column = 4 And Target.Row 8) Or IsEmpty(Target) Then Exit
Sub
If MsgBox("Confirm that you want to sign up for " & Date, vbYesNo) = vbYes
Then
Target.Locked = True
Else
Target.ClearContents
End If
End Sub

Sharad

"Brian" wrote in message
...
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