I have an Active X combobox where the list is the contents of a list of cells. I have used ComboBox1.ListIndex = 0 to reset the list to the top entry. But when I do that it triggers the ComboBox1_Change() sub.
I thought of putting something into the sub to check if I am resetting the list or the user has actually selected something.
Is there a better way to reset the box to the top entry?