Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inputbox | Excel Discussion (Misc queries) | |||
Inputbox with VBA | Excel Discussion (Misc queries) | |||
InputBox | Excel Programming | |||
inputbox | Excel Programming | |||
Excel Macro Code invoking InputBox. | Excel Programming |