Activating a macro with a cell value

[Excelguruintraining]

How do I activate a macro based on a cell value?

 

[L. Howard]

How do I activate a macro based on a cell value?

There are a number of event code available in Excel that will do that.

Here is a site that has a lot of information on event macros.

Event Macros, Worksheet Events and Workbook Events

Howard

 

[My Aswer Is This]

---

 

[My Aswer Is This]

Try this:
Mary is the name of the Macro you want to run.
Modify this script to your liking
When you enter "Mary" into Range A1 the Macro will run.

To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Cells(1, 1).Value = "Mary" Then
Cells(1, 1).Value = ""
Call Mary
End If
End Sub

 

[Excelguruintraining]

So i have tried this code, and its not working. I want to change the value in Cell C17 based on the value in C8

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("C8").Value = "YES" Then
Range("C17").ClearContents
Range("C17").Value = "=IF(AND(C6=0,C7=0),0,IF(SUM(C6*C10)+SUM(C7*75)+SUM(E18:E19)<220,220,SUM(C6*C10)+SUM(C7*75)+SUM(E18:E19)))"


End If


End Sub

 

[Excelguruintraining]

I actually had it pasted in a module so i figured it out thanks.