Thread: ListBox Control
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default 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