How do you code Private Sub Worksheet_Change with multiple ValidateLookup Target's

Originally Posted by David A Coop

I'm not an expert in VBA, but you could try

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 17 Then
         ValidateLookup Target 
         FundingLookup Target
    End If    
End Sub

While you can only have one Worksheet_Change event, I believe you can have multiple calls.

I hope this helps, please let me know!

Regards,

David
[/COLOR][/SIZE]

David thank you, but that didn't work.

Rats....