>Hi everyone...
>I have severals sheet and in a cell I have the result operations, I want that when this value cells exceed some value.
>How do I that the excel return a message "The value has been exceed"
Andrews,
The only way I know in Excel, is to use this formula and change the cell's font color to red. If E1 is the cell with the accumulated total and 1000000 is the limit,
=IF(E1 >= 1000000,"Limit is reached","").
This works OK when the entries are made in Excel. When the data is coming from Fox, I keep track of the totals in Fox. If I need an amount that is calculated in Excel, I pass the value back to VFP and add it to the total.
There is supposed to be a way to write a function or procedure that will do this in VBA, but I have not been able to get it to work.