electronicspark
Newbie
Joined: 11 Oct 2011
Posts: 1
|
 Posted: Tue Oct 11, 2011 3:10 pm Post subject: run a macro based on validity of cell |
 |
|
Hi,
I recorded a macro to capture DDE data and paste it on next row as numbers.
I have a cell 'P2' that I set validity on to whole numbers, valid if it equals 0. If it equals 1 I need to run the macro. This cell works when I enter a '1' manually as it should, however when the cell result changes to 1 by the (DDE) formula it doesn't run.
I'm trying to find a way to run this 'capture' macro automatically when this cell changes from 0 to a 1. |
|
