auto refresh
10-4, Thanks Tom!
"Tom Ogilvy" wrote:
Excel doesn't calculate until you hit enter. for any practical purpose,
Macros don't run while in edit mode.
--
Regards,
Tom Ogilvy
"Lou Sanderson" wrote:
I have an excel spreadsheet I used to do conversions of different weights,
distances, and other units of measure. Its really simple, I put in a
numerical value to a particular cell, and then have another cell reference
that cell with a conversion factor (whatever it happens to be) and presto, my
values are converted to other units of value.
However, I have to enter the original number I want to convert and then move
off the cell or press "Enter" or something before the references kick in and
the conversions are spit back out. Is there a way to have these calculations
done AS I input my value vice after?
Thanks,
Lou Sanderson.
|