How do I include two Private Sub Worksheet_Change’s

Hi,

I have two Private Sub Worksheet_Change(ByVal Target As Range) in Sheet 1. One is to force text to Upper case and one is for Validation (automatically add/sort additions). Each one works correctly when it’s placed into the worksheet, but when the second is added I get a ‘Compile Error’ “Ambiguous name detected: Worksheet_Change”.

Is there a way that I can satisfy both requirements but without this problem occurring.

Any advice would be greatly appreciated.

Hello,

you need to put the code into one Sub only, one after the other. Use Goto instead of Exit Sub (where applicable)

Please Login or Register  to view this content.

Originally Posted by teylyn

Use Goto instead of Exit Sub (where applicable)

\1

@romperstomper:

@Jessy, without looking too much into what the code actually does:

Please Login or Register  to view this content.

If you arrange it this way, the first IF statement only runs on the cells that qualify. Then the rest of the code runs in the same event.

cheers,

@romperstomper: I read you. Just had a lovely dish of spaghetti for dinner....

@Jessy, without looking too much into what the code actually does:

Please Login or Register  to view this content.

If you arrange it this way, the first IF statement only runs on the cells that qualify. Then the rest of the code runs in the same event.

cheers,

Teylyn,

Thanks for that, it works fine now. Thanks very much for your time.

J

Hello everyone,

I am having a similar issue as well. The existing code I have will automatically insert the current date and time in Column 18 when Column 17 status is changed.

What I want my code to do in addition to, is update Column 30 as well when Column 29 is changed.

How can I run both under one private sub? Is it possible?

Any assistance is appreciated. Thanks all!

Here is my code:

sdpnoy,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.