Default cell value before user input

[wotaj]

Hello everyone. I have what I thought would be a simple task but I have not been able to find an answer anywhere. I need a cell to display a default value (something like "Input Here") which a user can overwrite with a value. When the value is erased, the cell should return to the default. Preferably, it'd be great if the cell reset to the default value whenever the workbook is opened as well (i.e. won't save the user's input value).

Any help is appreciated.

Thanks,
AJ

[MrShorty]

This is a challenge because a cell can really only contain one piece of information. You are asking it to hold two.

The way I would set something like this up is to use three cells (considering there are millions of cells available, using two more cells should not be a problem). For example:

A1 contains "default" value
B1 contains "manual override" value where the user can input a value.
C1 contains a simple IF() function like =IF(ISBLANK(B1),A1,B1). Now, C1 will contain the default value from A1 until the user enters something in B1. Then the value in B1 carries over to C1. When the user clears B1, C1 reverts back to the default value in A1.

[ARGK]

Hi
Please see solution attached.
There is code behind the worksheet tab that inserts "Input here" as soon as a cell is cleared by the user. There is also a piece of code behind the "This Workbook" object that automatically clears previous values input by the previous user.
Hope this helps.
Good luck.
Tony

[mdatwell]

I downloaded the file and see that for any active cell the constant is Input Here. How do I create code for multiple cells with different constants?

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread