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
Bookmarks