Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
A simple visual basic program
Dear sir,
I am knowing nothing about Visual Basic Program. However, I need it for certain task which I feel it can help me a lot to manage my Excel spreadsheet. My question: I want to write a very simple visual basic program which allow me to reach a worksheet very quickly. My ideal situation is that press a button in worksheet A and will reach worksheet B or other very quickly. Is there any quick program regarding my request? Thanks, Wilchong -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200810/1 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
A simple visual basic program
Assign this simple macro to the button
Public Sub GotoSheetB() Application.Goto Worksheets("Sheet B").Range("A1") End Sub change the sheet name to suit. You could also setup a hyperlink and link it to another sheet. -- __________________________________ HTH Bob "wilchong via OfficeKB.com" <u43231@uwe wrote in message news:8c093a037a75e@uwe... Dear sir, I am knowing nothing about Visual Basic Program. However, I need it for certain task which I feel it can help me a lot to manage my Excel spreadsheet. My question: I want to write a very simple visual basic program which allow me to reach a worksheet very quickly. My ideal situation is that press a button in worksheet A and will reach worksheet B or other very quickly. Is there any quick program regarding my request? Thanks, Wilchong -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200810/1 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
A simple visual basic program
Hi,
You don't really need code for this. Right click the 'fast forward/rewind' button to the left of Sheet 1 tab and you get a popup list of all the worksheets in your workbook. Click one and you are taken to that sheet. Mike "wilchong via OfficeKB.com" wrote: Dear sir, I am knowing nothing about Visual Basic Program. However, I need it for certain task which I feel it can help me a lot to manage my Excel spreadsheet. My question: I want to write a very simple visual basic program which allow me to reach a worksheet very quickly. My ideal situation is that press a button in worksheet A and will reach worksheet B or other very quickly. Is there any quick program regarding my request? Thanks, Wilchong -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200810/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
In visual basic | Excel Worksheet Functions | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Visual Basic | Excel Discussion (Misc queries) | |||
Visual Basic Help | Excel Discussion (Misc queries) |