Fade text in a cell, disappeared when we input new text.

[geniusideas]

Hi, all.

Actually I'm trying to create something like database in excel but I
need user to input data into excel sheets. My intention is to create
example in each cell where user can see fade text or blur text in this
cell. When user start enter their text this fade text will
disappeared. How to do it in excel vba? anyone can help much
appreciated.Thanks
This mostly found in web application when we try to input user name or
password..

 

[GS]

geniusideas formulated the question :

Hi, all.

Actually I'm trying to create something like database in excel but I
need user to input data into excel sheets. My intention is to create
example in each cell where user can see fade text or blur text in this
cell. When user start enter their text this fade text will
disappeared. How to do it in excel vba? anyone can help much
appreciated.Thanks
This mostly found in web application when we try to input user name or
password..

You could use Conditional Formatting to set default text to some shade
of grey. As long as the user doesn't re-enter the same text it will
revert to the normal color.

Also, you may want to have a look into using the built-in Data Form for
user input instead of users directly entering the data into the
worksheet.