I have a drop-down list box on sheet A of a workbook that triggers the
_change() routine of another drop-down list box on sheet B, BEFORE triggering
its own _change() routine. The list boxes do not have the same name. It only
happens when both lists have a selected item and one is changed. I have used
the "Caller" property which tells me that an error called the routine but I
can't find any link between these two rotines, their linked cells or fill
cells. Can anyone help explain this or how I can interrogate the system to
find out its path?

I'm betting that you have the linkedcell or the listfillrange on the same sheet.

If you move those to another sheet, does it work ok?

In fact, another option is to remove the linkedcell and listfillrange and
populate the "linkedcell" via code and populate the listbox via code.

Broadband Al wrote:

I have a drop-down list box on sheet A of a workbook that triggers the
_change() routine of another drop-down list box on sheet B, BEFORE triggering
its own _change() routine. The list boxes do not have the same name. It only
happens when both lists have a selected item and one is changed. I have used
the "Caller" property which tells me that an error called the routine but I
can't find any link between these two rotines, their linked cells or fill
cells. Can anyone help explain this or how I can interrogate the system to
find out its path?

--

Dave Peterson

I have checked the linked cell and list fill - I have even deleted both boxes
and recreated them in design time - the same occurs. I haven't tried
run-time but I would really like to understand what is happening here. Any
other ideas?

"Dave Peterson" wrote:

I'm betting that you have the linkedcell or the listfillrange on the same sheet.

If you move those to another sheet, does it work ok?

In fact, another option is to remove the linkedcell and listfillrange and
populate the "linkedcell" via code and populate the listbox via code.

Broadband Al wrote:

I have a drop-down list box on sheet A of a workbook that triggers the
_change() routine of another drop-down list box on sheet B, BEFORE triggering
its own _change() routine. The list boxes do not have the same name. It only
happens when both lists have a selected item and one is changed. I have used
the "Caller" property which tells me that an error called the routine but I
can't find any link between these two rotines, their linked cells or fill
cells. Can anyone help explain this or how I can interrogate the system to
find out its path?

--

Dave Peterson

Sorry, no.

Broadband Al wrote:

I have checked the linked cell and list fill - I have even deleted both boxes
and recreated them in design time - the same occurs. I haven't tried
run-time but I would really like to understand what is happening here. Any
other ideas?

"Dave Peterson" wrote:

I'm betting that you have the linkedcell or the listfillrange on the same sheet.

If you move those to another sheet, does it work ok?

In fact, another option is to remove the linkedcell and listfillrange and
populate the "linkedcell" via code and populate the listbox via code.

Broadband Al wrote:

I have a drop-down list box on sheet A of a workbook that triggers the
_change() routine of another drop-down list box on sheet B, BEFORE triggering
its own _change() routine. The list boxes do not have the same name. It only
happens when both lists have a selected item and one is changed. I have used
the "Caller" property which tells me that an error called the routine but I
can't find any link between these two rotines, their linked cells or fill
cells. Can anyone help explain this or how I can interrogate the system to
find out its path?

--

Dave Peterson


--

Dave Peterson