[Hi polashd,
This is probably way too late to help you but it may help someone else.
I did what you did and of course got the same result. Put your routine in Initialize, not DropButtonClick.
For a full explanation see http://www.contextures.com/Excel-VBA-ComboBox-Lists.html
Hope this...