Results 1 to 12 of 12

Macro to Access Worksheet Via Popup Box

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-07-2008
    Location
    sCOTLAND
    MS-Off Ver
    Office 2003 SP3
    Posts
    256

    Macro to Access Worksheet Via Popup Box

    I have a macro below that gives me a popup box that lets me type in the new sheet i want to access. etc(sheet1.xls) It give me 2 boxes one i must type the old sheet i currently access etc(sheet0.xls) and the next is the new sheet i will now be accesssing. Is there a way to change this so i only get one box that will let me type in the new sheet i want to access?


    Sub Formulas_Click()
    
        Dim Old_Sheet As String, New_Sheet As String
    
    Old_Sheet = InputBox("Please enter sheet name currently being referenced")
    New_Sheet = InputBox("Please enter sheet name you wish to reference")
    
    With Sheets("STOCK").Range("G5")
    
        .Formula = Replace(.Formula, Old_Sheet, New_Sheet, , , vbTextCompare)
    
    End With
    Last edited by JimmiOO; 01-19-2010 at 08:53 AM.

Thread Information

Users Browsing this Thread

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

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