InputBox code
 

Hi,
Try out my SheetMenu.xls

I can modify it to suit.

Download it from http://www.geocities.com/excelmarksway

Basically, it hides all the worksheet tabs but shows them
in a fixed bar form in a tabstrip. At the moment, it lists
all sheets, including hidden and very hidden. All sheets
are now visible. You can only access menus by clicking a
cell, then pressing the ALT key. Use the arrow keys to
move through the menis. Escape key. See info on site for
more info.

regards
Mark

-----Original Message-----
New to programming Excel VB, so bear with me....
I want to have a InputBox which will activate a worksheet
in a workbook that
was just opened with Workbooks.Open. I am able to build
the InputBox with
Application.InputBox and activate the sheet with
Sheets.Activate, but what I
need help with is to write the syntax to 1. requires the
user to either enter
a valid string or end the macro with a cancel
commandbutton; and 2. handle
the error if the user enters an invalid worksheet name
(invalid because it's
not in the workbook, nothing more complex than that).
Thanks in advance for
any help.

John
.