Cells with instructions which disapper when data entered

Hi,

I needed some help in creating a template for people. In the template, I want to create cells which instruct the user on what need to be filled in that cell.

For eg. go to www.m-w.com In the box, it says 'Enter word or phrase'. When you click to enter a word, this line vanishes. I want to create a similar thing in Excel.

In Excel, for eg, in a cell it should say 'Enter Name' and when the user enter his name, this instruction should vanish. Also, this instruction should be in GREY and when they user enters his name it should be BOLD BLUE.

Any help guys?
Thanks.

Try this, make sure any input cells start with Enter.

Please Login or Register  to view this content.

Cheers Mike.. the 2nd one works real well.

I noticed a way around this. If i hit the space bar in a cell, it will remain blank. So users will not input the data by pressing the space bar. Anyway around this??

Thanks!

have you tried the example I posted, it works on any cell that starts with "Enter"?

Originally Posted by bullandthebear

Mick,

How do I do this in the 2nd code that you sent? Cheers

Yes it does, try deleting the instruction in a cell without entering anything. The message re-appears

Enter a name & the new entry remains.

Hello gtz101,

Welcome to the Forum.

This Thread is over 5 years old, and your chances of eliciting any response is about less than Zero.

It is always better to Start your own Thread, and for convenient reference, post a link of this Thread in your own new Thread.

Sit back and enjoy the responses!

Regards.