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

Hello,

I have the following code on a worksheet:

Please Login or Register  to view this content.

I also have the following code in Module1

Please Login or Register  to view this content.

This works great!

My question is, I have seven (7) other columns I need to apply this to.

I created the following in module1 underneath the above code:

Please Login or Register  to view this content.

Which I think is correct, however I am at a loss on how to code the worksheet_change since I have been reading I can only have one sub worksheet_change.

I have tried exit sub, exit, etc but I do not know enough about vba to figure this out.

Thanks

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

Please Login or Register  to view this content.

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


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Originally Posted by David A Coop

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

Please Login or Register  to view this content.

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

Maybe if you posted a scaled down version of your workbook, we could have a look.

Regards,

David