Prev: Get all sheets names in one sheet
Next: Capturing Real Time Data
From: Wael Fathy Wael on 23 Feb 2010 02:37
I want to run an event or a mcaro only when a certain cell is changed.
i.e., if the cell A1 value is changed, then do such and such ...
From: Luke M on 23 Feb 2010 09:04
Right click on your sheet tab, view code. Paste this in and modify to suit:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub

'Do something here

End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Wael Fathy" wrote:

> I want to run an event or a mcaro only when a certain cell is changed.
> i.e., if the cell A1 value is changed, then do such and such ...
 | 
Pages: 1
Prev: Get all sheets names in one sheet
Next: Capturing Real Time Data