I have a workbook The first sheet is a summary of a work roster. Then there
are other sheets with each day of the month. Is it possible to design a 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 advance

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

Hi,

For user entry you can use input box

dim var
var=application.inputbox("prompt message")
then you could loop through all the sheet and compare the var value
with cell a2 in each sheet.
:)


--
anusha2525
------------------------------------------------------------------------
anusha2525's Profile: http://www.excelforum.com/member.php...o&userid=35408
View this thread: http://www.excelforum.com/showthread...hreadid=551776