why would a combobox execute its "change" code when a button on the
userform is clicked? there is no code relating the button to the
combobox. it was not doing this before. I am confused. I even ran a
backup of the program (when it did work correctly) and that did not
work correctly either.

I meant "click" event. the code within a combobox "click" event is
exectued when the button is pushed. sorry

Jacob wrote:
> why would a combobox execute its "change" code when a button on the
> userform is clicked? there is no code relating the button to the
> combobox. it was not doing this before. I am confused. I even ran a
> backup of the program (when it did work correctly) and that did not
> work correctly either.