| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wanting to Create A Command Button Command
I am wanting to create a command button that once it is clicked on it will
change the active worksheet to the next worksheet in the workbook. For example, if I am on worksheet1 and click the button it will select worksheet2 and so on. I would like to create it so I do not have to have seperate command buttons for each page if at all possible. Thanks Bumper |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wanting to Create A Command Button Command
hi bumper338
ActiveSheet.Next.Select Why not use the shortcuts Ctrl PgUP and Ctrl Pg Down -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "bumper338" wrote in message ... I am wanting to create a command button that once it is clicked on it will change the active worksheet to the next worksheet in the workbook. For example, if I am on worksheet1 and click the button it will select worksheet2 and so on. I would like to create it so I do not have to have seperate command buttons for each page if at all possible. Thanks Bumper |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wanting to Create A Command Button Command
Thanks that is what I was looking for.
I don't want to use shortcuts because it will only confuse my end users. Thanks again, Bumper "Ron de Bruin" wrote: hi bumper338 ActiveSheet.Next.Select Why not use the shortcuts Ctrl PgUP and Ctrl Pg Down -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "bumper338" wrote in message ... I am wanting to create a command button that once it is clicked on it will change the active worksheet to the next worksheet in the workbook. For example, if I am on worksheet1 and click the button it will select worksheet2 and so on. I would like to create it so I do not have to have seperate command buttons for each page if at all possible. Thanks Bumper |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wanting to Create A Command Button Command
Be sure that you test if the last sheet is selected before you run the code line
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "bumper338" wrote in message ... Thanks that is what I was looking for. I don't want to use shortcuts because it will only confuse my end users. Thanks again, Bumper "Ron de Bruin" wrote: hi bumper338 ActiveSheet.Next.Select Why not use the shortcuts Ctrl PgUP and Ctrl Pg Down -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "bumper338" wrote in message ... I am wanting to create a command button that once it is clicked on it will change the active worksheet to the next worksheet in the workbook. For example, if I am on worksheet1 and click the button it will select worksheet2 and so on. I would like to create it so I do not have to have seperate command buttons for each page if at all possible. Thanks Bumper |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create attachment command button | Excel Discussion (Misc queries) | |||
| Create a command button in Excel using C# | Excel Programming | |||
| How to Create a Command Button | Excel Discussion (Misc queries) | |||
| How can I create a Floating Command Button | Excel Programming | |||
| Create Command Button from Code | Excel Programming | |||
Linear Mode
