How to have a Macro run based on a value in a cell

[tlinton]

Hi All,

I am wondering how to have a macro run based on a value in a cell.

Objective:

To have a row automatically cut from one sheet and pasted into another (existing) sheet based on a value of "closed" in the row in question without having to click a button that calls a macro.

Extra:

I have written Macros that can cut and paste rows from one sheet to another based on a value, but I always have to create a button and have it call the macro. I am not asking y'all to write the macro, as I would like to take another stab at that. I am just wondering if it is possible to have a macro run on its own when a value of "closed" is chosen from a list in a cell.

Attached:

I have attached the workbook that I am trying to make this happen for so as you can have a better idea of what I am dealing with.

Thanks in advance!

Tom L.

[Kramxel]

Please Login or Register  to view this content.

[tlinton]

Do I put this is as a private sub? or does it matter?

[tlinton]

This is what I have so far, but it doesn't seem to be working...

Please Login or Register  to view this content.

[Kramxel]

It would need to be in a sub yes, and you would need to specif what Y is?

[humdingaling]

Please Login or Register  to view this content.

use ThisRow as Row that changed to closed