ListBox Control
 

Hi,

Is there a way to turn off the ListBox_Change event? I have a Multi-Select
ListBox and when a user selects a particular line I use the Change event to
update other lines in the same ListBox. This of course fires off the Change
event again for each line I toggle.

This is not a problem as I have incorporated a flag to skip the event when
appropriate, but I was wondering if there was a simpler way to temporarily
turn it off. Application.EnableEvents didn't work.

TIA
Charlie

ListBox Control
 

Check out this link perhaps...

http://www.cpearson.com/excel/SuppressChangeInForms.htm
--
HTH...

Jim Thomlinson


"Charlie" wrote:

Hi,

Is there a way to turn off the ListBox_Change event? I have a Multi-Select
ListBox and when a user selects a particular line I use the Change event to
update other lines in the same ListBox. This of course fires off the Change
event again for each line I toggle.

This is not a problem as I have incorporated a flag to skip the event when
appropriate, but I was wondering if there was a simpler way to temporarily
turn it off. Application.EnableEvents didn't work.

TIA
Charlie

ListBox Control
 

That's essentially the way I did it. I thought there might be a property I
missed or something. Thanks for replying.

"Jim Thomlinson" wrote:

Check out this link perhaps...

http://www.cpearson.com/excel/SuppressChangeInForms.htm
--
HTH...

Jim Thomlinson


"Charlie" wrote:

Hi,

Is there a way to turn off the ListBox_Change event? I have a Multi-Select
ListBox and when a user selects a particular line I use the Change event to
update other lines in the same ListBox. This of course fires off the Change
event again for each line I toggle.

This is not a problem as I have incorporated a flag to skip the event when
appropriate, but I was wondering if there was a simpler way to temporarily
turn it off. Application.EnableEvents didn't work.

TIA
Charlie