Combining two Private Sub Worksheet_Change

[bdf0827]

I'm having some issues here. I have two Private Sub Worksheet_Change that I need in one worksheet. I can't figure out how to make it work with both private subs. Below is my coding. Any ideas would be so helpful!!

Please Login or Register  to view this content.

[shg]

Try this:

Please Login or Register  to view this content.

[bdf0827]

That code didn't work for me. Let me tell you what it needs to do because the current code can be re-written probably. I'm not sure if its the most effective way or if its compatible with eachother.

I'm going to attach the document and then explain what I'm trying to have happen.

1) worksheet named current: when I change the status in status column to Booked - the entire row will be deleted and moved to the Booked worksheet.
2) worksheet named current: when I change the status in the status column to DNMQ - the entire row will be deleted and moved to the DNMQ worksheet.
3)worksheet named current: when I change the status in the status column to Application, I want todays date to appear in the App Date column (G). I don't want this date to change each time its updated or saved though. A static date if you will. Also, if I change from Approved to closing I dont want the date to change in the column G. Once its there I don't need it to change for tracking purposes.
4) Finally, when there is a change in columns A-F I want another static date to appear in column J. This date wont change until their is any change in columns A-F.

Any help or ideas would be so appreciated.

[Leith Ross]

Hello bdf0827,

There is and always will be one and only one Worksheet Change event per worksheet. All the code therefore must be combined into the one event module.

[bdf0827]

Right...? That's what I'm trying to figure out how to do. Not disputing the fact that there can be only one change event.

Hello bdf0827,

There is and always will be one and only one Worksheet Change event per worksheet. All the code therefore must be combined into the one event module.

[shg]

That code didn't work for me.

That's not very helpful. Did it do nothing? Something, but not what you wanted? In what way?

Are you looking for someone to code to your specifications (aka, a consultant), or someone to help you help yourself?

[bdf0827]

It didn't work as in it did nothing. And I'm trying to learn this stuff. It's hard having to filter through the sarcasm everyone seems to post.

That's not very helpful. Did it do nothing? Something, but not what you wanted? In what way?

Are you looking for someone to code to your specifications (aka, a consultant), or someone to help you help yourself?

[royUK]

Find another forum then

You haven't even used the suggested code

[bdf0827]

Really, Roy? Can you not read? I said it didn't work. Stop trolling. Troll!

Find another forum then

You haven't even used the suggested code

[royUK]

It's not used in your attachment so how can we tell if you have used it correctly?

Any way uou have the option to go