Results 1 to 3 of 3

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

Threaded 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.

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