Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pop up box, searching worksheets and running macros help please
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pop up box, searching worksheets and running macros help please
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pop up box, searching worksheets and running macros help please
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching Worksheets | Excel Discussion (Misc queries) | |||
Searching Across Worksheets: Please help! | New Users to Excel | |||
searching multiple worksheets | Excel Worksheet Functions | |||
Searching Textboxes on worksheets | Excel Programming | |||
Searching with Macros | Excel Programming |