| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run macro
Hello I have the following macro:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$D$9" Then Call Calculation End If End Sub How do I set it up to run the macro "Calculation" after I changed the value in D9 rather than when I select cell D9? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Run macro
Ed,
Use the change event: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$D$9" Then Call Calculation End If End Sub HTH, Bernie MS Excel MVP "Ed" wrote in message ... Hello I have the following macro: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$D$9" Then Call Calculation End If End Sub How do I set it up to run the macro "Calculation" after I changed the value in D9 rather than when I select cell D9? thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Run macro
That was simple... thanks!!
"Bernie Deitrick" wrote: Ed, Use the change event: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$D$9" Then Call Calculation End If End Sub HTH, Bernie MS Excel MVP "Ed" wrote in message ... Hello I have the following macro: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$D$9" Then Call Calculation End If End Sub How do I set it up to run the macro "Calculation" after I changed the value in D9 rather than when I select cell D9? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| error when running cut & paste macro | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
Linear Mode
