AutoFilter & UserForm

  • Thread starter Thread starter chrisdarl
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The autofilter is disable using the userform 3
Autofilter with optional criteria 3
Advanced Filter Error - I cannot spot my Error 3
Use userform to select autofilter requirements 0
Weird ignoring of one item in a loop 5
How to set range to autofiltered visible cells? 7
Autofilter by combobox selection 1
If/Elseif AutoFilter Macro 4

Back
Top