Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run sub when one cell is changed
I know i can run private subs based on something like this
Private Sub Worksheet_Change(ByVal Target As Range) if target.address = "c20" then ......... But in the name of efficiency is there a way to name a sub so that it is not even activated unless a specific cell is changed. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
run sub when one cell is changed
sorry for the double post but i am having trouble posting. I keep getting the
service is temporarily unavailable messages. "NDBC" wrote: I know i can run private subs based on something like this Private Sub Worksheet_Change(ByVal Target As Range) if target.address = "c20" then ........ But in the name of efficiency is there a way to name a sub so that it is not even activated unless a specific cell is changed. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
run sub when one cell is changed
The short answer is no. Something has to send a signal that the macro needs
to run. That something is an event that Excel can detect. Then something has to tell Excel what to do after that event is detected. That is the VBA code in this case. The name of the macro for Worksheet_Change is a predefined constant that tells Excel to react to changes in the worksheet that the code underlies. So it all ties together. The problem lies in detecting the change, without using the change event. "NDBC" wrote in message ... I know i can run private subs based on something like this Private Sub Worksheet_Change(ByVal Target As Range) if target.address = "c20" then ........ But in the name of efficiency is there a way to name a sub so that it is not even activated unless a specific cell is changed. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Log who last changed a cell in a row...(incl Multi-Cell changes) | Excel Programming | |||
Format changed when the details in cell changed | Excel Worksheet Functions | |||
Can Comment in a cell be changed as the content in another cell ?? | Excel Discussion (Misc queries) | |||
if cell has been changed... | Excel Worksheet Functions | |||
in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? | Excel Worksheet Functions |