Event Triggers
 

I am working on a worksheet (2003 sp1 Excel).
I have several combboxes. When I enter a value in another worksheet cell,,
one of these combos change events are triggered. it then pasese on to other
combo change events. I added a new worksheet and change a values in one of
the cells, it hapens. Why is this behavior. If a change takes place in a
worksheet, these combos_change events should not trigger. I have not linked
up any cell with the combos.


MVM

Event Triggers
 

Do you have .listfillrange associated with that combobox? Is that on the same
sheet?

Try putting that list on another sheet (or drop the .listfillrange and fill with
..additem).

MVM wrote:

I am working on a worksheet (2003 sp1 Excel).
I have several combboxes. When I enter a value in another worksheet cell,,
one of these combos change events are triggered. it then pasese on to other
combo change events. I added a new worksheet and change a values in one of
the cells, it hapens. Why is this behavior. If a change takes place in a
worksheet, these combos_change events should not trigger. I have not linked
up any cell with the combos.

MVM

--

Dave Peterson

Event Triggers
 

Many many thanks Dave. I have been struggling with this for the last two
weeks. I have no words to praise your suggestion/help. thank you very much.

i had a list in another sheet. that range is named and used in these combos
..listfillrange.

Now the program is running as expected. when it comes to VBA, these things
are very different from VB

MVM

"Dave Peterson" wrote:

Do you have .listfillrange associated with that combobox? Is that on the same
sheet?

Try putting that list on another sheet (or drop the .listfillrange and fill with
..additem).

MVM wrote:

I am working on a worksheet (2003 sp1 Excel).
I have several combboxes. When I enter a value in another worksheet cell,,
one of these combos change events are triggered. it then pasese on to other
combo change events. I added a new worksheet and change a values in one of
the cells, it hapens. Why is this behavior. If a change takes place in a
worksheet, these combos_change events should not trigger. I have not linked
up any cell with the combos.

MVM

--

Dave Peterson