Results 1 to 3 of 3

Macro drop down list to select the next sheet tab

Threaded View

Nunzio Macro drop down list to... 11-24-2014, 10:13 PM
humdingaling Re: Macro drop down list to... 11-24-2014, 11:00 PM
Nunzio Re: Macro drop down list to... 11-24-2014, 11:59 PM
  1. #1
    Registered User
    Join Date
    03-24-2007
    Posts
    88

    Macro drop down list to select the next sheet tab

    I am trying to create a macro with a drop down list that will take me to the next selected sheet. I do have an input box macro attached, but would like to add a drop down list of avaiable sheets. Thanks Rick

    Sub LOI_Num()
    '
    ' LOI_Num Macro
    ' Macro recorded 12/22/2009 by SCJ User
    '
    ' Keyboard Shortcut: Ctrl+l
    '
    
        
    
    Dim strsheet As String
    ' dim i as integer
    
    strsheet = Application.InputBox("put sheet name", "Sheet Name Select", , , , , , 2)
    
    ' you can put 1 instead of 2 in inputbox for number if you wanna select for 'index in that case
    ' your code will be
    ' with thisworkbook.worksheets(i)
    '.select
    '.activate
    'end with
    ' i suggest to select by name it is easy ..atleast for me
    
    
    With ThisWorkbook.Worksheets(strsheet)
    .Select
    .Activate
    End With
    
    
    End Sub
    Last edited by Nunzio; 11-24-2014 at 11:59 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-14-2014, 12:52 AM
  2. Drop down list to select sheet name
    By FinProfessional in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-06-2013, 02:23 PM
  3. Macro to Select Drop Down List
    By rmmohan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2013, 04:20 PM
  4. [SOLVED] autofilter-new sheet macro with drop down list
    By apatel615 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2013, 12:50 PM
  5. Replies: 5
    Last Post: 10-27-2005, 01:55 PM

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