I think you would want to fetch the date you want with something like

WantDate = Application.InputBox("Enter Date Required")

then search through each worksheet comparing WantDate with A2

Something like...

numofsheets = Activeworkbook.sheets.count
i = 1
while i <= numofsheets
do
sheets(i).activate
if Range("A2") = WantDate
exit sub
else
i = i+1
loop
wend


Not tried it, but it should be close!

Regards,

Gareth
Paul Wrote:
I have a workbook The first sheet is a summary of a work roster. The
there
are other sheets with each day of the month. Is it possible to design
pop
up box, which lets the user input a date, then goes to that worksheet
The
dates for each seperate worksheet are found in a2 of every sheet.

would so love your help.... Thanks in advanc

--
pianoma
-----------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...fo&userid=3371
View this thread: http://www.excelforum.com/showthread.php?threadid=55177