Run Macro
Is there a way to run the code only when a certain cell is changed? Not when
any cell on the sheet is changed "JLGWhiz" wrote: Use the Change event in the worksheet code module. Right click the sheet tab for the sheet where you want the code to execute, then click on View Code in the pop up menu. This opens the worksheet code module. At the top of the code window you will see General and Declarations in two smaller windows. Click on the General window first, then click Workbook, then select "Change" from the drop down list. You should then see the two lines below: Private Sub Worksheet_Change(ByVal Target As Range) End Sub The code to be executed for any change to the page can be put between these two lines. "ranswert" wrote: Is there a way to run a macro each time a cell contents are added or changed? Thanks |
Run Macro
On Jan 15, 4:37*pm, ranswert
wrote: Is there a way to run the code only when a certain cell is changed? *Not when any cell on the sheet is changed "JLGWhiz" wrote: Use the Change event in the worksheet code module. *Right click the sheet tab for the sheet where you want the code to execute, then click on View Code in the pop up menu. *This opens the worksheet code module. *At the top of the code window you will see General and Declarations in two smaller windows.. * Click on the General window first, then click Workbook, then select "Change" from the drop down list. *You should then see the two lines below: Private Sub Worksheet_Change(ByVal Target As Range) End Sub The code to be executed for any change to the page can be put between these two lines. "ranswert" wrote: Is there a way to run a macro each time a cell contents are added or changed? Thanks- Hide quoted text - - Show quoted text - If Target.Address = "A1" Then End If |
Run Macro
This will change the value in Range("A1") based on the value
of cell C3 only. The A1 value will be eithe 1 or 2. Private Sub Worksheet_Change(ByVal Target as Range) Set Target = Range("C3") If Target.Value Range("B2") Then Range("A1").Value = 1 Else Range("A1").Value = 2 End If End Sub "ranswert" wrote: Is there a way to run the code only when a certain cell is changed? Not when any cell on the sheet is changed "JLGWhiz" wrote: Use the Change event in the worksheet code module. Right click the sheet tab for the sheet where you want the code to execute, then click on View Code in the pop up menu. This opens the worksheet code module. At the top of the code window you will see General and Declarations in two smaller windows. Click on the General window first, then click Workbook, then select "Change" from the drop down list. You should then see the two lines below: Private Sub Worksheet_Change(ByVal Target As Range) End Sub The code to be executed for any change to the page can be put between these two lines. "ranswert" wrote: Is there a way to run a macro each time a cell contents are added or changed? Thanks |
All times are GMT +1. The time now is 05:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com