Calling macro on cell change

Hi.
I want to call a macro when some text is changed in a cell. How do you reckon that can be done?

I tried calling the macro from worksheet_change method but that did nothing for some reason.

Cheers

Worksheet_Change should work... maybe the prob is in your macro...

the ff code illustrates this (as what happens in my worksheet):

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "Cell " & Target.Address & " now contains " & Target.Value
End Sub

Originally Posted by schoujar

Hi.
I want to call a macro when some text is changed in a cell. How do you reckon that can be done?

I tried calling the macro from worksheet_change method but that did nothing for some reason.

Cheers

Worksheet_change works for all data that is typed into the cells.
But the data I am concerned with at the moment is chosen rom a picklist.

Originally Posted by T-容x

Worksheet_Change should work... maybe the prob is in your macro...

the ff code illustrates this (as what happens in my worksheet):

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "Cell " & Target.Address & " now contains " & Target.Value
End Sub

by "picklist", do you mean the Data Validation list or list from "Pick From Drop-down List..." context menu?
both still work for me...

what list are you using? (aside from the 2 above)

Originally Posted by schoujar

Worksheet_change works for all data that is typed into the cells.
But the data I am concerned with at the moment is chosen rom a picklist.