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

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/

.

searching a date range.
 

Yeah thanks for the fast reply, that worked just fine! cheers. chri

--
Message posted from http://www.ExcelForum.com