Hi all,

new question I can't seem to figure out:

I have a macro in the worksheet under Worksheet_BeforeDoubleClick()
that macro executes the below code. 

Please Login or Register  to view this content.
when double clicking the cell (usually will have data in the cell that needs to be modified), it invokes the inputbox. However, if you click cancel it clears the cell. What I was trying to do was capture the original cell value and if the user clicks 'cancel' it will input the original cell value back in its place.. however this doesn't work.

Suggestions?