Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox change fires on workbook close when textcol <1 or -1
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox change fires on workbook close when textcol <1 or -1
Weird Excel problem. The only thing I can think of is that you set a flag
in BeforeClose (since it runs before the combobox change event) and check it in the change event code: -- Jim "sophie" wrote in message ... |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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox change fires on workbook close when textcol <1 or -1
i like your idea. Thank you.
"Jim Rech" wrote: Weird Excel problem. The only thing I can think of is that you set a flag in BeforeClose (since it runs before the combobox change event) and check it in the change event code: -- Jim "sophie" wrote in message ... |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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo box change event fires twice | Excel Programming | |||
Combobox_Change event fires on workbook close | Excel Programming | |||
Worksheet_Change fires even when no change? | Excel Programming | |||
How Capture Cell Value Before Change Event Fires? | Excel Programming | |||
File|Close w/Save fires Workbook_Open twice | Excel Programming |