Using Autofilter to prompt for criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob - 20 Jan 2006 17:40 GMT

I created a macro that will autofilter for certain records. I was thinking
of creating a query but the autofilter will return only the records
specified, correct. If so, then is there a way to write within the macro to
display a popup for prompting for criteria that would be entered into the
popup and the macro complete from there?

Reply to this Message

Don Guillett - 20 Jan 2006 17:50 GMT

As ALWAYS, copy/paste your coding efforts here for comments.

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I created a macro that will autofilter for certain records. I was thinking
> of creating a query but the autofilter will return only the records
> specified, correct. If so, then is there a way to write within the macro
> to
> display a popup for prompting for criteria that would be entered into the
> popup and the macro complete from there?

Reply to this Message