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


--
schoujar
------------------------------------------------------------------------
schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574
View this thread: http://www.excelforum.com/showthread...hreadid=399362

Calling macro on cell change
 

Worksheet_Change should work... :eek: 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



schoujar Wrote:
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


--
T-®ex
------------------------------------------------------------------------
T-®ex's Profile: http://www.excelforum.com/member.php...o&userid=26572
View this thread: http://www.excelforum.com/showthread...hreadid=399362

Calling macro on cell change
 

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.




T-®ex Wrote:
Worksheet_Change should work... :eek: 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


--
schoujar
------------------------------------------------------------------------
schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574
View this thread: http://www.excelforum.com/showthread...hreadid=399362

Calling macro on cell change
 

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)



schoujar Wrote:
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.


--
T-®ex
------------------------------------------------------------------------
T-®ex's Profile: http://www.excelforum.com/member.php...o&userid=26572
View this thread: http://www.excelforum.com/showthread...hreadid=399362