Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
searching a date range.
Hi i have a list of dates from 2001 to 2004. i am wanting to be able t
have a macro that calls a msgbox and asks for the year that they wan to display. so if they type 2003 all the records in year 2003 ar shown. if there are no records for that year then a error box i recieved. my date format is 12/02/01 all in one cell. does anyone kno how i am able to do this ? Thanks for your help. Chri -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
searching a date range.
Hi Chris
why not use 'Dat6a - Autofilter' for this. Just add a helper column with the formula =YEAR(A1) and let the user filter the data with this helper column? -----Original Message----- Hi i have a list of dates from 2001 to 2004. i am wanting to be able to have a macro that calls a msgbox and asks for the year that they want to display. so if they type 2003 all the records in year 2003 are shown. if there are no records for that year then a error box is recieved. my date format is 12/02/01 all in one cell. does anyone know how i am able to do this ? Thanks for your help. Chris --- Message posted from http://www.ExcelForum.com/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
searching a date range.
Yeah thanks for the fast reply, that worked just fine! cheers. chri
-- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SEARCHING RANGE | Excel Discussion (Misc queries) | |||
Searching a date range to output values according to a constant. | Excel Discussion (Misc queries) | |||
Searching a date range to output values according to a constant. | Excel Discussion (Misc queries) | |||
searching a range for a sum... | Excel Worksheet Functions | |||
3d range searching | Excel Discussion (Misc queries) |