Runing a macro on by changing a value of the cell

**luv2glyd** · 09-11-2008, 03:22 PM

Is there a way to change the value of cell A1, for example, from one value to another, hit the enter key, and activate a macro this way.

A couple of qualifications:
- the value in cell A1 will never be the same (that is it could be -23.43 or .12)
- I can not simply tie the macro to the "enter" key as there will be numerous cells (A1, B3, C90 and so on) in the same sheet that I will need to do this with, each tied to a different macro.

Thanks for your help.

**Phil_V** · 09-11-2008, 05:50 PM

Right click on the worksheet's tab, View Code.

Paste the following code:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target
    Case Range("A1")
        MsgBox "You changed A1"
    Case Range("F3")
        MsgBox "You changed F3, and yes this is a different message"
End Select
End Sub

Change cell A1 and you'll get the message, change cell F3 and you'll get the other message. Any other cell does nothing. This code certainly isn't polished or bullet-proof, but it should give you the idea to start with

**luv2glyd** · 09-11-2008, 08:12 PM

that gets me closer! The only trouble is when I delete the value in any other cell, say B6, the first message appears....

**rylo** · 09-11-2008, 08:58 PM

Hi

Try this.

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
    Case "$A$1"
        MsgBox "You changed A1"
    Case "$F$3"
        MsgBox "You changed F3, and yes this is a different message"
End Select
End Sub

Note that if you highlight say A1:B3 and delete, you won't get any message. It is currently set to only action on single cells.
rylo

**luv2glyd** · 09-11-2008, 09:11 PM

great, that works!

If I wanted to call the same macro with changes in cells A1 and B1 and C4, what code would I need to insert in the 3rd line?

Thanks

**rylo** · 09-11-2008, 09:22 PM

Hi

Sorry, don't follow. Do you want it to action if you have a block of cells selected, or do you wish to nominate additional single address locations?

rylo