I am working in a little project for my department. I have 2 workbooks
Schedule Workbook and Forms Workbook. The Schedule workbook resembles
2004 calendar and contains hyperlinks to different worksheets on Form
Workbook.

What I am trying to do is create a mimic input box that will pop up a
soon as a hyperlink is clicked in Schedule workbook. Then when the use
enters a number they are taken to a particular worksheet on the Form
Workbook.

For example, One of the options in Schedule workbook is "Queens", bu
there are 4 different worksheets in the Forms workbook for Queens.
want a mimic input box to appear after the "Queens" hyperlink i
clicked then I want the user to enter a zip code and then be taken t
the right form out of the 4 in Forms Workbook.

(the reason I keep mentioning mimic input box is that as far as I kno
input boxes only serve for returning the value entered by an user an
placing that entry on a cell... thus my input box will need to resembl
an input box but have a different function, in my case after the valu
is entered, needs to be checked against a list of numbers (zip codes
and then as result open the right worksheet.)

Help on this matter will be greatly appreciated, I'm only a beginne
when it comes to VBA still reading the net for tips and trying to pu
pieces together... I know there must be guys in this forum that ca
write this simple procedure in their sleep... Please help me!

Also if anyone can recommend a book or 2 to start learning about VB
programming I would really be grateful. Thanks!

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

You can get user input with this code :-

MyInput = InputBox("Please enter something")
If MyInput = "" Then En

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