Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Guided Button???
Hi guys, I have 100 worksheets all with different names and a main menu. Fro the main menu I want to be able to press a button that opens an inpu box in which I can type the name of the worksheet I want to go to an then a macro will take me to that worksheet. I've been experimenting and have the following code in VB. It brings u an input box but then whenever I enter anything and click OK, an erro message appears. Could anyone give me a hand??? Thanks Mark Heres my code:- Sub RoundToZero() Worksheets("Main Page").Activate On Error GoTo PressedCancel Set Pub = Application.inputbox( _ prompt:="Enter your EKR Pubn Code", _ Type:=0) Worksheets("Pub").Activate Exit Sub PressedCancel: Resume End Su -- locutus24 ----------------------------------------------------------------------- locutus243's Profile: http://www.excelforum.com/member.php...fo&userid=1286 View this thread: http://www.excelforum.com/showthread.php?threadid=48342 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel users! Do-It-Yourself Dashboards, Reports, Guided Analytics and Business Presentations! | Charts and Charting in Excel | |||
Excel users! Do-It-Yourself Dashboards, Reports, Guided Analytics and Business Presentations! | Excel Discussion (Misc queries) | |||
User guided button??? | Excel Discussion (Misc queries) | |||
use a button to open a user form? | Excel Discussion (Misc queries) | |||
User name button access. | Excel Programming |