文件列表:

Navigator (0, 2008-03-27)
Navigator\Navigator.xls (34304, 2004-10-05)
Navigator\VBA Express Excel - Listbox to Display and Go To Worksheets.mht (53030, 2008-03-22)

Listbox to Display and Go To Worksheets Ease of Use Easy Version tested with 2000, 2002 Submitted by: firefytr Description: Displays a list of worksheets, and allows the user to choose one, then to navigate to it. Discussion: You may have lots of worksheets in your file, but you don't like right-clicking on the sheet tab scroll arrows, or your users just don't know how. Use this code in your application to help users navigate through a multiple-sheet file. How to use: 1. Open your file and hit Alt+F11 to open the Visual Basic Editor (VBE). 2. Hit Insert-UserForm. 3. Design a form like the one in the sample file and then right-click it in the left-hand side of the code window, and choose View Code. 4. Paste the UserForm code above into the code window at the right. 5. Now, on the left-hand side, double-click the worksheet from which you wish to navigate. 6. Paste the Worksheet code into the code window at right. 7. Close the VBE. Go to the Worksheet in which you pasted the code. 9. Place a command button on it using the Control Toolbox. 10. Get out of design view. 11. Save the file.

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：