VBA to access Pivot Table Autofilter dropdown box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using 2003

Would like, within a VBA procedure, to make Excel Autofilter choices from
selected fields.

I prefer not to enter my choices via an InputBox or MsgBox as the choices
are typically 35+ characters.

In short,

Sub Test
With ManyWorkSheets

.... series of (non-Pivot Table sheet) w/s processing

.... Select "Pivot Table" worksheet
.... cause two-field's dropdown boxes to activate (one at a
time)
.... continue series of (non-Pivot Table sheet) procedures.

Next ManyWorkSheets

End With

End Sub

Any thoughts? (keep it clean!)

Thanks Dennis
 
My additional thoughts FWIW:

For non-pivot table autofilter selections:

1) I could "Advanced-filter">Unique Records only, to a helper
sheet, yielding choices for the columns (fields) of
concern.

2) Then code VBA to toggle down each Unique Rec inserting
same, one by one, as the filter choice.

For Pivot Tables the challenge is greater as the dropdown box choices permit
"select all" or "select none" (actually one item must be selected but the
select none or all are easy ways to safley clear previous choices)

Dennis
 
Back
Top