How can I get visual basic to prompt the user for a data entry that will
subsequently be used in an autofilter.

You use an inputbox statement.

Sub aa()
Dim Answer As String
answer = InputBox("Enter Criteria", "Filter input")
Selection.AutoFilter Field:=1, Criteria:=answer
End Sub

Hopes this helps.

---
Per

"BG Mark" skrev i meddelelsen
...
How can I get visual basic to prompt the user for a data entry that will
subsequently be used in an autofilter.

Dim myStr as string
....
mystr = inputbox(Prompt:="Please enter something")
if trim(mystr) = "" then
msgbox "you didn't enter anything"
else
msgbox mystr & " was entered"
end if




BG Mark wrote:

How can I get visual basic to prompt the user for a data entry that will
subsequently be used in an autofilter.

--

Dave Peterson