AutoFilter & UserForm

C

chrisdarl

Hi, i have a autofilter on my sheet, i am wanting to create a userfor
with drop down list boxes containing the same values as in th
autofilter criteriers.

Anyone know how to do this in VBA?

Many thanks Chris
 
A

arno

Hi Cris,
with drop down list boxes containing the same values as in the
autofilter criteriers.
Click to expand...

make a "copy" of your data with an advanced filter (set to unique values),
load this list into your drop down.

arno
 
Top