Forum Discussion
Excel Formula
How can I do this...
I want instructional text in grey to appear in a cell until a user types in it. When someone types in it the text becomes regular black. If they delete what they typed it converts back to grey.
Thank you in advance for help.
If you are looking for something like to give user the help tip.
then i suggest using the Data Validation Input Message and how it works is that when user hover the mouse over the cell or if they select the cell, it will show the text.
i recorded a gif few second video that shows how you can do that.
5 Replies
If you are looking for something like to give user the help tip.
then i suggest using the Data Validation Input Message and how it works is that when user hover the mouse over the cell or if they select the cell, it will show the text.
i recorded a gif few second video that shows how you can do that.
Thank you. Very helpful.
You are welcome. Thanks for the feedback.
- No formula can do it. The text that users entered will replace the instructional formula. When the users clear the text that they enter, the instructional text formula has gone. You can only accomplish this goal by VBA.
If you do not want a VBA solution, the workaround is that the instructional text should be in a cell that is not supposed to be modified by the users.Thank you for your information. I am not sure what a VBA solution means.
