Automation Error - Data Returned from Visible Row Fails to Load to Form Combobox

Hello,

I'm using Excel 2007. When I select from "Bin Number" combobox, the date field is populated with filtered and copied date. But when I select a date from the "Intake Date" combobox, the filter runs but the data in column “B” from the visible rows returned from autofilter is not loaded into the "Fish Tag No. From Bin" comboxbox if date 20/09/2014 is selected from "Intake Date" combobox. If I select 01/03/2015 from the "Intake Date" combobox the Fish Tag No. From Bin comboxbox loads properly. It appears to me that Excel is not distinguishing between the autofiltered visible Bin Number 2 for date 20/09/2015 and the hidden Bin Number 2 for date 01/03/2015 so Excel appears to loop, I have to restart Excel and before Excel closes before restart I get an Automation Error: Object has disconnected from its clients.

I've narrowed it down to Excel not distinguishing between same Bin Number and different date by changing the source data, so if I use Bin Number 3 with two different dates in source data, automation error arises. This error only arises if the same Bin Number with two different dates exists in the source data.

I would appreciate any help that could be offered. Thanks in advance.

Test Daily Bin Temp.xlsm

After much research, I found the solution for this problem. Many thanks to those who attempted to solve this problem.

The solution was to use the same last row variable for the autofilter and the adding of values to the DBTIntakeDate combobox. The changes are shown in red in the DBTIntakeDate combobox change event below.

Please Login or Register  to view this content.