Hi Carim,

Sorry for the delay. Anyhow, I'm not much of a seasoned macro/UserForm
operator so I'd sure appreciate a few more details on how to create a
UserForm (incl. the related macro). I did look-up UserForms and learned how
to install a pop-up questionairre according to their sample, but I can't
figure out how to customize it to my own criteria. Moreover, I definitely
don't know how to install a macro that would activate my pop-up
questionnaire. Currently, I have the following worksheet event on my
spreadsheet:

If Intersect(Target(1), Me.Range("Y53:BN53")) Is Nothing Then Exit Sub

If Intersect(Target(1), Me.Range("Y53:BN53")) Is Nothing Then Exit Sub
If Target(1).Value = 250 Then
If MsgBox("Was vehicle held over the weekend?", _
vbYesNo) = vbYes Then
MsgBox "Please give reason with approving Manager's name"
End If
End If
End Sub

I would like for the User's "reason for the weekend rental" to appear in
cell Y104 and the "Approving Manager's Name" to appear in cell AB104.

Is this possible?

Thank you in advance.


"Carim" wrote:


To help you go a bit further ...
Two remarks :

1. Your "pop-up questionnaire" is a UserForm you will have to design
which will specifically show all the fields you want to have filled in
...

2. For this userform to pop-up, as soon as a given cell is updated, you
will have an event macro, attached to the worksheet, which will show the
form to be filled in ...

HTH
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=530820