Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoRun Macro with a delay to give user the choice to cancel the macro | Excel Programming | |||
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |