Drop-down list triggering the wrong routine

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
Sorry, no.

Broadband said:
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?
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

active combobox - possible to configure as display value andcoordinate value? 3
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Data Validation List problem 5
Populate list or combo box from closed workbook 4
Pick from drop-down list gives empty or erroneous result 6
Define the Range of a drop-down list 5
Copy worksheet without triggering events 2
preventing comboboxes from triggering when sheet copied 1

Back
Top