Running the macro, it still doesn't work. I've tried using your code
for my workbook and it kind of works, but with a delayed response. If
I click on the drop down , choose my selection, it does't populate that
cell with the corresponding name unless I pop back into the cell. If I
leave the cell and then go back to the cell than it updates the cell
with the corresponding name.


--
pyarb
------------------------------------------------------------------------
pyarb's Profile: http://www.excelforum.com/member.php...o&userid=26803
View this thread: http://www.excelforum.com/showthread...hreadid=400570