I am looking for the code that will immediately drop the validation lis
when I enter into a giving cell.

Setting up the event is no problem, but I am stuck the code tha
actually drops the validation list.

I have tried using the macro recorder to emulate dropping the list, bu
it just doesn’t capture it.

If there is no method for dropping the list, I know that Alt+DownArro
accomplishes the task. Is there a way to force an OnKey upon enterin
the cell?

Someone is going to find this question trivial, or the answe
intuitive, but isn’t me. I appreciate any time that can be giving t
getting me through this issue.

Thanks,

Bir

--
Bir
-----------------------------------------------------------------------
Bird's Profile: http://www.excelforum.com/member.php...fo&userid=2446
View this thread: http://www.excelforum.com/showthread.php?threadid=46779