AutoFilter & UserForm  
Author Message
BadgerMK





PostPosted: Tue Apr 27 06:08:32 CDT 2004 Top

Excel Programming >> AutoFilter & UserForm

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.hide-link.com/

Excel227  
 
 
arno





PostPosted: Tue Apr 27 06:08:32 CDT 2004 Top

Excel Programming >> AutoFilter & UserForm 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