Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro whenever any cell is changed
I have a Validate macro in a spreadsheet that checks several fields whenever
the Validate macro button is clicked. Is there a way to call that macro any time any cell in the sheet is changed or selected. The clerks can't seem to click the button when they access the sheet. One of the import validation checks it does is check the Contact time for all rows which alerts us if a Tech hasn't touched base with us within the last 2 hours if his job is still open. Thanks in advance... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro whenever any cell is changed
Put your macro in the sheet module as a Worksheet_Change procedure by right
clicking the sheet tabViewCode. Click the window that says General, then click worksheet. That should load the declarations window from which you can select "Change" and that should then enter the following in the code module: Private Sub Worksheet_Change(ByVal Target As Range) End Sub Enter your code between the two lines. "bob engler" wrote: I have a Validate macro in a spreadsheet that checks several fields whenever the Validate macro button is clicked. Is there a way to call that macro any time any cell in the sheet is changed or selected. The clerks can't seem to click the button when they access the sheet. One of the import validation checks it does is check the Contact time for all rows which alerts us if a Tech hasn't touched base with us within the last 2 hours if his job is still open. Thanks in advance... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run macro automatically when cell content is changed? | Excel Worksheet Functions | |||
Run a macro when a cell is changed by an outside source | Excel Programming | |||
Run Macro when particular cell is changed? | Excel Programming | |||
Run Macro when particular cell is changed? | Excel Programming | |||
Run an excel macro when a cell value is changed | Excel Programming |