Control autofilter in macro and continue macro

Hi
I am new in vba. I want control
Selection.AutoFilter
ActiveSheet.Range("$A$1:$K$10000").AutoFilter Field:=1, Criteria1:= I Want control and choose

and then continue my macro

If is posible

Thanks for help.

Robert

You can't do user user input during a VBA command (except inputbox/msgbox).
The first should do it ActiveSheet.Range("$A$1:$K$10000").AutoFilter Field:=1, Criteria1:=inputbox("prompt") (there are opton for title and default if needed