+ Reply to Thread
Results 1 to 3 of 3

two independent drop down list on one sheet, with various macro's attached

Hybrid View

  1. #1
    Registered User
    Join Date
    06-13-2015
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    2

    two independent drop down list on one sheet, with various macro's attached

    have two independent drop down list on one sheet with various macro attached to each drop down- the when pick from the second drop down list is does not work it intercepts zero- have tried to nest but does not work -is it possible to two independent dropdowns with different macro;s on one sheets
    any help would be appreciated
    thanks



    Private Sub Worksheet_Change(ByVal Target As Range) 'Major customer and Internal Revenue
      
    If Not Intersect(Target, Range("K1")) Is Nothing Then
    
        Select Case Range("K1")
    
            Case "Costco": Costco
            Case "Overstock": Overstock
            Case "Wayfair": Wayfair
            Case "InternationalRev": InternationalRev
            Case "Blank":
        End Select
    
    End If
     
    End Sub
    
    Private Sub Worksheet2_Change(ByVal Target As Range) 'All Internal and External Monthly Incentive
    
    If Not Intersect(Target, Range("G1")) Is Nothing Then
    
        Select Case Range("G1")
    
            Case "InternalMoIncentive": InternalMoIncentive
            Case "OutsideRepAdam": OutsideRepAdam
            Case "MinorrepsP": MinorrepsP
            Case ",OutsideRepSS_S": OutsideRepSS_S
            Case "Blank":
        End Select
    
    End If
    
    End Sub
    Last edited by FDibbins; 06-13-2015 at 07:50 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: two independent drop down list on one sheet, with various macro's attached

    Private Sub Worksheet_Change(ByVal Target As Range) 'Major customer and Internal Revenue
    
    If Not Intersect(Target, Range("K1")) Is Nothing Then
    
    Select Case Range("K1")
    
    Case "Costco": Costco
    Case "Overstock": Overstock
    Case "Wayfair": Wayfair
    Case "InternationalRev": InternationalRev
    Case "Blank":
    End Select
    
    Elseif Not Intersect(Target, Range("G1")) Is Nothing Then
    
    Select Case Range("G1")
    
    Case "InternalMoIncentive": InternalMoIncentive
    Case "OutsideRepAdam": OutsideRepAdam
    Case "MinorrepsP": MinorrepsP
    Case ",OutsideRepSS_S": OutsideRepSS_S
    Case "Blank":
    End Select
    
    End If
    
    End Sub
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: two independent drop down list on one sheet, with various macro's attached

    Welcome to the forum

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I have added them for you - this time
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. [SOLVED] Macro drop down list to select the next sheet tab
    By Nunzio in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2014, 11:59 PM
  2. Macro: Using drop-down list to extract whole table from one sheet to another
    By binni88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-13-2013, 11:33 PM
  3. [SOLVED] Pull data using drop-down list (URGENT - ATTACHED)
    By ld2x07 in forum Excel General
    Replies: 3
    Last Post: 05-14-2013, 09:29 AM
  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: 18
    Last Post: 09-08-2012, 07:13 AM

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