Command Buttons
Command Buttons
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Command Buttons

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    What I have is a mutli page workbook and I would like to know how to use or program the command buttons to jump to the next page of the work sheet or to anothe rpage in the work book.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    To select the Next page use this code:

    ActiveSheet.Next.Select

    or the previous one

    ActiveSheet.Previous.Select

    To go to another page, there's an easier way, right click on the arrows at the left of the Worksheet Tabs, you'll see a list of all your sheets and you can click one of them to go instantly to it.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com