Best Answer

Use the control Worksheet_Change. See related links for a sample macro that will trigger a macro when the cell changes. Modify, as needed, to fit your specific situation.

User Avatar

Wiki User

โˆ™ 2010-03-19 10:53:48
This answer is:
User Avatar
Study guides

How much can you sell a mirraco icon option for

Road wheel torque settings for peugeot 106 1.4

What kind of data do you write on a data table

What tab or dialog box do you use to organize your sources

See all cards
27 Reviews

Add your answer:

Earn +20 pts
Q: How do you activate a macro in an excel sheet when a cell equals a predefine value?
Write your answer...
Still have questions?
magnify glass
Related questions

What is the record in excel?

Record in excel is used to record a macro. If you press record and perform any action on excel, all these actions are recorded and stored in a macro. You can run this macro again to preform the same task.

How do you get merged cells to auto height with out a macro in Excel?

I don't know about Excel 2007 but in 2003 you cannot do it with a macro. An inherent feature constratint of Excel 2003.

What is a macro in MS Excel?

A Macro is a small program which is typed into a Macro File. In Excel click Help on the toolbar then type "Macro". This will tell you what they are, what they do and how to create them. They are very useful. You can also on the toolbar click on "Tools" then "Macros" to see what is there.

Create date macro in excel?

The following is a record macro copied into the workbook open section of the workbooks properties. Enters date in a1 Private Sub Workbook_Open() Range("a1").Activate ActiveCell.FormulaR1C1 = Now() Selection.NumberFormat = "dd/mm/yyyy;@" End Sub The macro run's it's self when the file opens

What are two words an Excel macro ends with?

End Sub.

What is the virus that is attached to documents such as Word or Excel?

Macro virus

What is macro Excel?

Macro is feature in MS Excel software which records all the steps and all the steps can be repeated whenever a same task is required to be performed. It helps in reduction of time in performing monotonous task. Macro is available in Tools menu.

What virus attaches to documents such as word or excel files?

macro virus

How many lines of macro code an excel sheet accept?


What viruses attach themselves to documents such as word and excel?

Macro viruses

Can run access or excel macro codes on pdf files?

Yes! you can!

People also asked