Martin,
The setfocus works unless the user clicks outside the list box without making a choice. I will try to split the code up somewhat because if I just copy the entire thing to lostfocus it no longer works at all. I hate dropdowns!!
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!