As always, post your coding efforts for comments and suggestions.
c1 = InputBox("Enter Criteria 1")
MsgBox c1

--
Don Guillett
SalesAid Software

"Lorna B" wrote in message
...
I am building a macro so that people in my organization can produce reports
based on a customer satisfaction spreadsheet database. I need to be able
to
pull data from the customer responses based on date ranges and I am
thinking
that the autofilter is the best choice for this. I want people to be able
to
input a from date for the greater than = to choice in autofilter and input
and end date for the less than = to choice. I would then like to have
them
click on a radio button to initiate the macro and have the macro run the
routine to pull the information to a query spreadsheet from the
satisfaction
spreadsheet based on the dates given. Piece of cake I am sure for you MVP
types, but I am stumped on how to have the autofilter pull the dates for
the
query from the input cells. :(

Your help would be hugely appreciated.