Hi there

I am newbie here and I have a question regarding Excel VBA.
Though I done a search, but none of it could meet what I wanted.
My request is..

Let say I enter value in A1 & B1. In cell C1, I have a formula, =sum(A1:B1), which is the total. Now, I want to create a event change (VBA) to trigger a macro (to do something) when the value is greater than, say, 1000.

Any excel guru can help me out.
As I am still a Excel VBA novice, hope my questions can be explained in step by step.

Thank u.

Hope you find something here.

CPearson.com Topic Index (http://www.cpearson.com/excel/topic.aspx)

VBA Tips & Tricks: VBA Email Automation / VBA Mail Automation (http://vbadud.blogspot.com/2007/04/vba-email-automation-vba-mail.html)

Microsoft Excel (http://j-walk.com/ss/excel/index.htm)

http://web.archive.org/web/20031204013634/support.microsoft.com/default.aspx?scid=/support/excel/content/vba101/default.asp

Getting Started with Macros and User Defined Functions (http://www.mvps.org/dmcritchie/excel/getstarted.htm)

Microsoft Excel Language Reference (Microsoft Excel 97 Language Reference) (http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/office97/html/output/F1/D3/S5A341.asp)

Also look up the Excel Function IF Statement...

Excel does not have an event that is triggered when the value in a cell changes. Your best bet is to use something else to trigger a macros that runs down column C testing each value and performing an action accordingly.