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

--
Message posted from http://www.ExcelForum.com

Hi Cris,

with drop down list boxes containing the same values as in the
autofilter criteriers.

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

arno