I get it. But, I am unable to duplicate this with a control on the worksheet because when the worksheet is in Edit Mode (i.e., I am in the process of changing a cell value, but have not pressed "Enter"), the control on the worksheet will not drop down for me.
Since I cannot duplicate the problem, I cannot be sure my solution will fix it. But, try it anyway ... it can't hurt.
Does the drop down box have any code behind it? If so, then for the first line of code put this:
If not, then add this code:
Bookmarks