Could you please tell me what do I need to add or remove to the following
codes in order to make them like a (Event code) ? Thanks
====================================
Sub check the number()

Worksheets("Sheet1").Activate
Dim X(1 To 20) As Integer

X3 = 3
X4 = 3

For X4 = 3 To 18
If Cells(17, 13) = Cells(X4, 1) Then
Cells(17, 14) = Cells(X4, 3)
End If

'If 18 < Cells(17, 13) < 4 Then
'Cells(17, 14) = "OUT OF RANGE"
'End If

Next X4

End Sub

================================================== ==========================
=
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Afshin

Event code?

http://www.cpearson.com/excel/events.htm
http://www.mvps.org/dmcritchie/excel/event.htm

Write your code as a User Defined Function instead of a Sub()?

http://www.mvps.org/dmcritchie/excel/install.htm

Gord Dibben Excel MVP

On Mon, 27 Sep 2004 22:42:42 -0700, "A-Design"
wrote:

Hi,
How should I write my codes that can be getting executed automatically,
like
the way that excel formulas are getting executed at the back ground?
Thanks,
Afshin