Hmmmmn, if that's what he wants I do know of a way to do it with formulas only but you end up using autoshapes to create the illusion that the value is in the cell until you change it. It works really well for the right application but it may be more desirable to use VBA instead.