Multiple Macros From Multiple Dropdown Lists on one sheet.

Hi All,

I am trying to create a code that will pull macros from three separate dropdown lists (my example only has two) In this instance, this is for a mortgage audit and I want separate macros based upon the state the loan is in and if it's a government loan or not. Can someone tell me where I am going wrong? Thanks!


Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B4")) Is Nothing Then
Select Case Range("B4")
Case "California": California
Case "Florida": Florida
End Select
End If
End Sub




Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B3")) Is Nothing Then
Select Case Range("B3")
Case "FNMA": FNMA
Case "FHMLC": FHMLC
Case "VA": VA
Case "FHA": FHA
End Select
End If
End Sub

You cannot have more than one Worksheet_Change event associated with any one sheet so you have to combine your code into one macro. The following macro assumes you have a drop down list in cells B3, B4 and B5. I have entered generic data for B5. Change it to suit your needs. Please let me know how it works out.

Please Login or Register  to view this content.

MUMPS1 You are a lifesaver! Thanks so much!

My pleasure!

My apologies, Fotis1991. I did not see your post until after I had posted my reply.