sparky2205
Active Member
- Joined
- Feb 6, 2013
- Messages
- 482
- Office Version
- 365
- 2016
- Platform
- Windows
Not sure this is even possible but here goes.
I want a cell to be populated with ENTER NAME HERE unless the cell is populated with anything else.
But the cell can't contain a formula.
I'll expand a little
I have a form with a box (cell) which contains the default text ENTER NAME HERE. Nothing special about the cell.
When a user enters a name it obviously overwrites the default text.
What I want is, if the user deletes the name in the cell the default text ENTER NAME HERE automaticlly returns. i.e. if the cell is blank display the default text.
I'm looking for a non vba solution as if the form gets updated in the future which affects the cell address and I'm not around they won't have a clue how to fix it.
I want a cell to be populated with ENTER NAME HERE unless the cell is populated with anything else.
But the cell can't contain a formula.
I'll expand a little
I have a form with a box (cell) which contains the default text ENTER NAME HERE. Nothing special about the cell.
When a user enters a name it obviously overwrites the default text.
What I want is, if the user deletes the name in the cell the default text ENTER NAME HERE automaticlly returns. i.e. if the cell is blank display the default text.
I'm looking for a non vba solution as if the form gets updated in the future which affects the cell address and I'm not around they won't have a clue how to fix it.