Grime,

I recently developed a similar function. I used conditional formatting
to save the default value. So long as the target cell value matched
the default value, the target cell text was black. If the target cell
value differed from the default value, the target cell text was red.

I then assigned VBA code to the right-click event that replaced the
target cell value with the default value. I can send you/post the code
next week (it's at work).

All that to say, it can be done...and it is quite handy.

Gerry


grime wrote:
User inputs data into a cell. I have the "default" value of that cell
in another cell. I would like the user to be able to either
right-click or double-click on the input cell to restore the default
value.

Is that possible? Thanks in advance.


--
grime
------------------------------------------------------------------------
grime's Profile: http://www.excelforum.com/member.php...o&userid=19227
View this thread: http://www.excelforum.com/showthread...hreadid=476434