Results 1 to 3 of 3

Enter Sheet name to destination cell

Threaded View

  1. #1
    Registered User
    Join Date
    08-26-2009
    Location
    Lima, Peru
    MS-Off Ver
    Excel 2007
    Posts
    37

    Question Enter Sheet name to destination cell

    Hello all,

    I would like a button in (Sheet2) to do this operation when clicked: jump to (Sheet1) and enter Sheet2's name into cell B4, where this button is used in many sheets similar to Sheet2(aka2,3,4,5,6...) that all do the same to jump to sheet 1.

    Private Sub DashboardButton1_Click()
    Dim ws As Worksheet
    
        With Sheets("Dashboard")
            .Select
            .Range("B4").Formula = ws.Name
            .Range("B4").Select
        End With
    I think I just need to know how to properly call the sheetname variable... the above code does not work.

    Thanks for your help in advance!
    Last edited by mworonuk; 02-16-2010 at 04:30 PM.

Thread Information

Users Browsing this Thread

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

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