Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter
Hello, Could someone please advise on how I can accomplish the followin 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 en 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter
You can use input boxes for the start and end dates:
'================= Dim strA As String Dim strB As String strA = Application.InputBox("Start Date") strB = Application.InputBox("End Date") Selection.AutoFilter Field:=3, Criteria1:="=" & strA, _ Operator:=xlAnd, Criteria2:="<=" & strB '============================== Or, create dropdown list of dates on the worksheet using data validation: http://www.contextures.com/xlDataVal01.html Format these dates the same as the dates in column C. The user will select a start and end date from the dropdown lists, then run the AutoFilter macro: '================================== Selection.AutoFilter Field:=1, Criteria1:="=" & Range("K1").Value, _ Operator:=xlAnd, Criteria2:="<=" & Range("L1").Value '================================== longbow wrote: 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/ -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter
Thankyou Don for you help, much appreciated. Kind regards, Chris. : ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter
glad to help
-- Don Guillett SalesAid Software "longbow" wrote in message ... Thankyou Don for you help, much appreciated. Kind regards, Chris. :) ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |