i am using a combobox activex control with listfillrange of two columns of
data.
when i set the textcolumn property to 2 or 0 the combobox change event fires
when the workbook is closed. it does not fire if i set the textcolumn to 1 or
-1.
why?
i like to set the textcolumn = 2 to display the data in the 2nd col but i
dont want the
combobox to fire just because the user is closing the workbook.

can it be done?

Thank you for any help you can provide.