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

VBA Tips & Tricks: VBA Email Automation / VBA Mail Automation

Microsoft Excel

http://web.archive.org/web/200312040...01/default.asp

Getting Started with Macros and User Defined Functions

Microsoft Excel Language Reference (Microsoft Excel 97 Language Reference)

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.