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.

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.

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.