RookieTrader

Joe & Paul, Thanks for your replies. I have more questions for you though. I see how your code reads from the clipboard and then runs a macro depending on the clipboard contents, but I don't see how to get the contents of a spreadsheet cell to the clipboard automatically. Can a macro have a spreadsheet cell as an input and monitor the value of the cell? Can it then run the IF and Else commands using the cells value to determine which macro to run? I would like to continually monitor the values in a few spreadsheet cells and have a macro act on those values. I would need to be able to list the cell by file name, sheet #, and cell location on the spreadsheet to do this I think. Any ideas on how this could be accomplished? The only values for the cell would be 0 or 1. The macro could then act from there but how do I get it to read the value of the cell? Thanks for your help. David

Looking for a little help starting a macro. Can the results of a calculation in a spreadsheet cell start a macro? The result of 1 could start macro A, a 0 could start macro B just as an example. Is this possible with Macro Express? I feel sure it is but I haven't figured out how to do it yet. The spreadsheet is not excel but is something similiar. Any help would be greatly appreciated. David