Results 1 to 9 of 9

Drop down list to select sheet name

Threaded View

  1. #1
    Registered User
    Join Date
    12-03-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    8

    Drop down list to select sheet name

    Good Morning!

    I am trying to add a drop down list to my macro to allow the user to select from a list of names to name a new sheet created.
    I have the current macro which allows them to enter a sheet name, but I have decided I would prefer to provide a list to choose from as some formulas on another tab are dependent on the sheet name. How do I adjust the below to provide a list vs input box?

        Dim VariableSheetName As String
        VariableSheetName = InputBox("Sheet Name", "Enter Projection name")
        Sheets("Sheet1").Name = VariableSheetName

    Thanks in advance for any help you can provide!!!
    Last edited by FinProfessional; 12-06-2013 at 01:49 PM. Reason: code tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Linking drop down list to select from another list ?
    By slaughtontdc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-19-2013, 07:55 AM
  2. [SOLVED] Select from drop down list to show another drop down list in a different cel
    By ExcelRanger in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-22-2012, 04:27 PM
  3. How do I use one list drop down menu result to select another list?
    By steveinspain in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-02-2007, 02:59 PM
  4. Select:Drop down list
    By Not A Clue in forum Excel General
    Replies: 1
    Last Post: 11-11-2006, 08:21 PM
  5. Replies: 5
    Last Post: 10-27-2005, 01:55 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