Thread
:
AutoFilter
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
AutoFilter
Easy. Why not just look at vbe help index for INPUT BOX
then try
x=inputbox(etc
Selection.AutoFilter Field:=3, Criteria1:="=01JUL03", Operator:=xlAnd,
Selection.AutoFilter Field:=3, Criteria1:=""=" & x& "", Operator:=xlAnd,
--
Don Guillett
SalesAid Software
"longbow" wrote in message
...
Hello,
Could someone please advise on how I can accomplish the following
task:
I wish to create a macro that asks the user for two dates.
For example: The user may wish to AutoFilter all the records in the
spreadsheet that have a dates between 01 Jul 2003 and 31 Jul 2003.
Selection.AutoFilter Field:=3, Criteria1:="=01JUL03", Operator:=xlAnd,
_
Criteria2:="<=31JUL03"
I do not know how to get user input into the above VBA code.
I'd like two input boxes, one for the start date and one for the end
date.
Column 3 of the spreadsheet has a heading called Date Demanded.
Any help with this would be greatly appreciated.
Thanks,
Chris.
:)
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]