Ask Experts Questions for FREE Help !
Ask
    readeep's Avatar
    readeep Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Dec 30, 2007, 09:37 PM
    Cell to trigger a macro
    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.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Jan 8, 2008, 09:35 AM
    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Database date event trigger [ 2 Answers ]

How to write a trigger that will be executed on a specific date/day of every month/week? If you have any example, please describe.

Trigger Injections [ 1 Answers ]

I just found out from my MRI that I have protrusions in my C5 and C6 from a past wreck I had 5 years ago. I had Whiplash pretty bad - but went through tons of therapy for 6 months. But, guess it was never better and has worsen over time. My doctor wants me to go to pain management now. What can...

Macro system [ 2 Answers ]

:confused: what do you think is the most significant macro system in today's family life. (church, Social agencies, health care program, etc)

View more questions Search