Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command Buttons & ActiveX Controls
What I would like to do is have a command button on click, to go to another
sheet on a specified cell range in the same workbook. Its just that I do not know how to create macros or codes to make any command button work. Any help me would be much appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command Buttons & ActiveX Controls
Public Sub MyButton_Click() Worksheets("Sheet2").Select End Sub -- __________________________________ HTH Bob "aussiegirlone" wrote in message ... What I would like to do is have a command button on click, to go to another sheet on a specified cell range in the same workbook. It's just that I do not know how to create macros or codes to make any command button work. Any help me would be much appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command Buttons & ActiveX Controls
And to get to a specific range:
Public Sub MyButton_Click() application.goto Worksheets("Sheet2").range("X99"), scroll:=true 'or false?? End Sub aussiegirlone wrote: What I would like to do is have a command button on click, to go to another sheet on a specified cell range in the same workbook. Its just that I do not know how to create macros or codes to make any command button work. Any help me would be much appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveX Controls | Excel Discussion (Misc queries) | |||
Tab between ActiveX controls | Excel Discussion (Misc queries) | |||
ActiveX controls | Excel Discussion (Misc queries) | |||
ActiveX Controls | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) |