Select next or previous Criteria in autofilter list

[larsvantongeren]

Hi, I'm trying to develop some vba code to allow a user to quickly select the next option in a autofilter list. Also another version to select the previous option in the list. The idea being to attach these to macro buttons or shortcut keys to allow user's to much more quickly cycle through the options than by manually using the autofilter drop down (very tedious). Really this is just to make data review easier, by displaying only one set of related rows at a time.

thanls lars

[kev_]

Hi Lars

Use "Custom View" (see Data tab)
- allows you to save the filtered view and select it whenever you want
- so when data changes, the same filters can be applied without having to set them
- and the VBA is simple (one line per button)

In attached file Click on buttons 1 , 2 , 3 , 4 to see 4 different views

code behind button:

Please Login or Register  to view this content.

where to find custom view:

CustomView.jpg