I have a sheet with 2 list boxes on it. I have code attached to each list box on the _change event.
The lined cells for each box are in another sheet, but do not relate to each other (there are no interdependent formula).
The problem occurs when i change a value in the first box, the code that is run is the _change code for the 2nd box.
Also i have a Application.EnableEvents = False at the start and Application.EnableEvents = true at the end of the code, but the code still loops round the _Change.
Is there something happening in the background that i can see or is there a setting i need?
Any help from someone suffereing similar appreciated.
Cheers
nic
The lined cells for each box are in another sheet, but do not relate to each other (there are no interdependent formula).
The problem occurs when i change a value in the first box, the code that is run is the _change code for the 2nd box.
Also i have a Application.EnableEvents = False at the start and Application.EnableEvents = true at the end of the code, but the code still loops round the _Change.
Is there something happening in the background that i can see or is there a setting i need?
Any help from someone suffereing similar appreciated.
Cheers
nic
