Hi
I have checked around but cannot seem to find out an answer for this.

My worksheet has 24 cells where I am able to enter a number, and I want
to be able to trigger a macro when a cell has a new number input.

This I can do with

Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
If Intersect(Target, Range("C31")) Is Nothing Then

Exit Sub
Else


If True Then Run ("gettemp1")

End If
Application.ScreenUpdating = True

End Sub

This only works if you only have 1 cell to check on.

How can I check on 24 different cells and each triggering a different
macro?

I thought I may have to add a command button after each cell but the
user may forget to push it and not update the rest of the sheet.

Thanks in advance.

Warren


--
cuewoz
------------------------------------------------------------------------
cuewoz's Profile: http://www.excelforum.com/member.php...o&userid=32161
View this thread: http://www.excelforum.com/showthread...hreadid=519139