+ Reply to Thread
Results 1 to 4 of 4

Changing Worksheets Using Dropdown List (not combo box) that doesn't include sheet names

  1. #1
    Registered User
    Join Date
    01-02-2017
    Location
    Toronto, Canada
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    6

    Changing Worksheets Using Dropdown List (not combo box) that doesn't include sheet names

    I'm using the following VBA Code to change worksheets based on the a selection from a dropdown list that isn't a combo box:

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    On Error Resume Next
    If Not Intersect(Target, Range("C6")) Is Nothing Then
    Application.ScreenUpdating = False
    Sheets(Range("AH6").Value).Select
    Application.ScreenUpdating = True
    End If
    End Sub

    C6 is where the dropdown is and AH6 is where the name of the appropriate worksheet name appears based on the selection in C6.

    My problem is that the sheet doesn't change just by selecting the item. I have to click on a cell other than C6 and then click on C6 for the worksheet change to occur. How can I get the sheet to change just by selecting the dropdown list item and NOT having to click anywhere else.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Changing Worksheets Using Dropdown List (not combo box) that doesn't include sheet nam

    Try removing "Selection" from Worksheet_SelectionChange
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    01-02-2017
    Location
    Toronto, Canada
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    6

    Re: Changing Worksheets Using Dropdown List (not combo box) that doesn't include sheet nam

    Perfect. Thanks!

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Changing Worksheets Using Dropdown List (not combo box) that doesn't include sheet nam

    No problem, glad it worked for you.

+ Reply to Thread

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-07-2016, 01:56 PM
  2. Replies: 7
    Last Post: 12-23-2015, 07:43 AM
  3. Code to select worksheets based on sheet names in a list
    By cdself in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-08-2013, 01:00 PM
  4. How to list names of all worksheets in my summary sheet And how to template a sheet?
    By liajet24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2013, 07:10 PM
  5. Copy cells from multiple worksheets into one list with Sheet names.
    By ksamarin88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2012, 04:45 PM
  6. Replies: 0
    Last Post: 08-22-2012, 03:52 PM
  7. Word Form Dropdown List Doesn't Appear
    By Ra21V12eN in forum Word Formatting & General
    Replies: 2
    Last Post: 08-22-2011, 03:50 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