combobox change fires on workbook close when textcol <>1 or -1

's Computer Specifications

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.

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:0963CA77-6928-4C68-9B79-(E-Mail Removed)...
|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.

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
> news:0963CA77-6928-4C68-9B79-(E-Mail Removed)...
> |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.
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access Problem: Combobox.setfocus fires combobox.OnClick event	Hal Levy	Microsoft Access Form Coding	5	31st Jul 2009 03:54 AM
Combobox_Change event fires on workbook close	Geoff	Microsoft Excel Programming	3	17th Dec 2007 08:30 PM
Copying sheet or saving workbook kicks off ComboBox change Sub	sultann@gmail.com	Microsoft Excel Programming	0	16th Aug 2006 06:22 PM
combobox.SelectedIndexChanged fires twice ??	Steve F.	Microsoft VB .NET	2	23rd Nov 2004 05:08 PM
comboBox TextChanged event fires twice because Items.Insert() fires the event too...	Rob Hindman	Microsoft Dot NET Framework Forms	2	25th Aug 2003 07:10 AM