Compile Error - Detected

[RJ1969]

Hello
What if there is 2 or more than of " Private Sub Worksheet_SelectionChange(ByVal Target As Range)".
I received a compile error.

here is the sample code:

Please Login or Register  to view this content.

[TMS]

You need to combine them into one event handler. Should be straightforward the way they are written.

[6StringJazzer]

You may not have two Subs with the same name. If you need multiple actions for the same event, you have to use logic to put them into a single sub.

This has been compiled but not tested. If it does not do what you want please attach your file.

Please Login or Register  to view this content.

[RJ1969]

Ok...I think this work.
How do I add message box between this code:

Please Login or Register  to view this content.

thanks.

[RJ1969]

I was able to figured it out.
Thank you all.

[TMS]

You're welcome.


Worked out what? I described what was necessary and 6SJ did it all for you.

[RJ1969]

Hi
I am not good combining them into one event handler. Is there a way to rename this code?

Private Sub Worksheet_SelectionChange(ByVal Target As Range

Like: Private Sub Worksheet1_SelectionChange....

[rorya]

Not if you want it to run automatically.