Curious...
I have an Active X drop-down list control...
A Dropdown list is a ComboBox (Default control name 'ComboBox1'), this is not the same thing as a ListBox. A ListBox does not have a Style property while a ComboBox does. So which do you have? I'd guess a ListBox as Style is missing and the code must refer to a valid control.
Whichever, both controls have a ListIndex property. This is used to get or set the current selected/highlighted item. The line
resets the ListIndex to 1 every time the code executes so just remove/comment that line.
Bookmarks