nathan2314
07-08-2008, 05:58 AM
Good Morning all :hi:
I just finished writing some vba code that will change the color of a line in a graph (x line) if it drops below another line (y line) for any value of x vs. y.
Now the graph is tied to several different cells in my spreadsheet at different places (other than the straight values that the graph reads in to create the lines). Cells that when the values are changed they do different calculations/manipulations and change the actual values that the graph reads in to create the lines.
Ok, so now I want the spreadsheet to run this vba code anytime any cell that indirectly/directly affect the graph is changed. How can I do that. I know I can create a button attached to the macro that when clicked will run the macro but is there anyway to have the macro run when someone just changes a cell a value? I'd have to do this for several different cells. Or maybe a better way ?
help! :)
I just finished writing some vba code that will change the color of a line in a graph (x line) if it drops below another line (y line) for any value of x vs. y.
Now the graph is tied to several different cells in my spreadsheet at different places (other than the straight values that the graph reads in to create the lines). Cells that when the values are changed they do different calculations/manipulations and change the actual values that the graph reads in to create the lines.
Ok, so now I want the spreadsheet to run this vba code anytime any cell that indirectly/directly affect the graph is changed. How can I do that. I know I can create a button attached to the macro that when clicked will run the macro but is there anyway to have the macro run when someone just changes a cell a value? I'd have to do this for several different cells. Or maybe a better way ?
help! :)