Run a Macro from a cell value becoming "1"
Posted by Bob Earl on January 31, 2002 10:54 PM
I am trying to run a macro to import external data to a predetermined range of cells whenever a specific cell changes from a "0" to "1". The specific cell is tied through DDE to another external data source.
I have the cell DDE set up and running. I have the macro written and it currently runs when I pick a box.
I just need to find a way to trigger the macro from the specific cell.
Please help if you can.