Fill listbox after autofilter has been applied

Hi there,

I'm looking for some code that would allow me to fill a listbox on a userform with the resulting columdata (column D) after the columns to the left have been autofiltered.

Anyone who could be of assistance, please ?

Thanks in advance
Eric

Thanks, however when I apply the code the header of the column is included (which it should not) and the listbox includes all values in the column, while only the visibles in d:d after the autofilter has been applied (in column a,b and c) should be shown. And yes, the autofilter is applied in the code of the form.

Regards - Eric

Eric

Slight mod to the previous code

Please Login or Register  to view this content.

rylo

Many thanks indeed, works now as intendend !