Excel vba to select next option in autofilter drop down menu

[gberg]

I have a table that I want to cycle through the items in one of the columns using the autofilter. There are thousands of rows and hundreds of items to filter by so I was hoping to have a macro to cycle though each unique item in Column B of my table.


Here is an example of the data in Column B that I would want to filter by one by one with a macro

8I3096

8I3097

8I3097

8I3097

8I3098

8I3098

8I3099

8I3100

8I3100

8I3101

8I3102

8I3103

 

[Jaafar Tribak]

The modeless MessageBox pauses the macro and allows you to access any cell in the workbook.

It does allow to access any cell but it does not allow for any editing/changes.

The above is what prompted me to code this custom MsgBox function which halts code execution, but allows for interacting with excel and for editing cells.

MsgBox that waits for user input

Hello everyone, As we know, a MsgBox is modal, ie: halts code execution and blocks the excel user interface while it is on display. Whereas a modeless userform allows user interaction, but doesn't halt the execution of the caller code : Dim oForm As New UserForm1 oForm.Show vbModeless MsgBox...

www.mrexcel.com

I hope it is useful & robust enough.