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