Results 1 to 4 of 4

Go to page button using 2 cells as reference

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2012
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    54

    Talking Go to page button using 2 cells as reference

    go2page.xlsm


    Hello there, Happy New Year to you!

    I'm trying to achieve a "go to page button" using more than one cell as the reference.
    My pages are named based on the contents of 2 cells and separated by a [comma space] - ", "

    The Code I have at the moment is:
    Private Sub CommandButton1_Click()
        Sheets(Range("A1").Value).Activate
    End Sub
    However, I really need the reference to include both "A1" & "B1".

    Here is my "Rename Worksheet" Macro if it helps any.
    Private Sub CommandButton1_Click()
    Dim rs As Worksheet
    
    For Each rs In Sheets
            rs.Name = rs.Range("A1") & ", " & rs.Range("B1")
       Next rs
    
    End Sub



    Thanks for any help guys and gals
    Last edited by r2fro; 01-03-2014 at 10:30 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Button which links the front page to another page depending on a data validation cell valu
    By greg19 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-12-2013, 03:59 AM
  2. Button to jump down the page
    By rmoney in forum Excel General
    Replies: 2
    Last Post: 08-05-2010, 04:46 PM
  3. Create nth copy of page 2, then reference first page with incremented row
    By leesjunkmail001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2009, 02:21 AM
  4. [SOLVED] Macro that copy page to page just some filled cells
    By LC in forum Excel General
    Replies: 0
    Last Post: 05-13-2005, 07:06 PM
  5. Inserting page number & page count in cells
    By Jeff in forum Excel General
    Replies: 0
    Last Post: 05-02-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1