This may be a question for stackoverflow I'm not sure,
I would like to know if it is possible to program a cell in Excel 2010 to have text that disappears once you click into the cell. The sort of programming you would apply to a text input block on a html form.
I would like to do this as I require a way in which to inform a user of what to place in the cell. I am aware that comments can do this effectively but I would like the text to be present without prompt with mouse hovering or the Show all comments button.
Would I use scripting to do this? Or is there a feature in Excel?