Kevin

The description is maybe a little vague.

Is the 'date' in C a true date eg. 1/1/2000 or simply a text year, eg. 2000?
What is being summed? Or did you want the cells counted.

Is it imperative that you have the button, inputbox, etc. This could be
achieved on the other sheet by placing combobox on the sheet with the values
in and using simply a SUMIF() (If you are looking to sum) function to
display the total anywhere in a worksheet cell.

--
HTH
Nick Hodge
Southampton, England



"Kevin" wrote in message
...
I have a spreadsheet with Start date, (Column C) and
Service, Column E)... What I want to do is, on another
tab, have a button that states total... When the button is
clicked, a input box comes up with a drop down list of
years, 2000, 2001, 2002, 2003... The user hits what year
the they want to see, and a message box pops up with the
total... The code would have to search through Column C
for the requested year, and add when the criteria is met
add Column E... I'm assumming that I would need two
ranges, Start Range and Service Range??

Thanks in Advance
Kevin...