Start macro on cell change
 

Hi,

i would like run a macro whenever the value of a cell
change.This for all the cells in a certain column.

Thankyou
regards
Giorgio

Start macro on cell change
 

Right Click on the sheet name and select "View Code" then paste the
following code.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
MsgBox "A1 value is changing"
End If
End Sub


--
Regards,
Rocky McKinley


"Giorgio" wrote in message
...
Hi,

i would like run a macro whenever the value of a cell
change.This for all the cells in a certain column.

Thankyou
regards
Giorgio

Start macro on cell change
 

Sorry code should have said:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
'Type your Macro name here
MsgBox "A1 value is changing"
End If
End Sub

--
Regards,
Rocky McKinley


"Giorgio" wrote in message
...
Hi,

i would like run a macro whenever the value of a cell
change.This for all the cells in a certain column.

Thankyou
regards
Giorgio

Start macro on cell change
 

Very interesting.
How would I cause the message box to appear for 1 second then disapear as if
acknowledged?
Brian Tozer

Rocky McKinley wrote:
Sorry code should have said:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
'Type your Macro name here
MsgBox "A1 value is changing"
End If
End Sub


"Giorgio" wrote in message
...
Hi,

i would like run a macro whenever the value of a cell
change.This for all the cells in a certain column.

Thankyou
regards
Giorgio

Start macro on cell change
 

http://www.xl-logic.com/pages/vba.html
look for please wait
--
Don Guillett
SalesAid Software

"Brian Tozer" wrote in message
...
Very interesting.
How would I cause the message box to appear for 1 second then disapear as
if
acknowledged?
Brian Tozer

Rocky McKinley wrote:
Sorry code should have said:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
'Type your Macro name here
MsgBox "A1 value is changing"
End If
End Sub


"Giorgio" wrote in message
...
Hi,

i would like run a macro whenever the value of a cell
change.This for all the cells in a certain column.

Thankyou
regards
Giorgio