text placeholder

[Guest]

hello everyone...

I asked this before, but didn't have any luck. I would like to do the following: have a certain piece of text (ie- "enter age here") in cell A1, unless the user enters their age there. When it is deleted, I would like the text to reappear (ie. "enter age here") In other words, this text would be a placeholer that informs the user of what to enter, dissappears when the user enters the text, and then reappears when the information is deleted from the cell. Any ideas? Thanks in advance!!!

 

[Guest]

giacomo,

Great- it worked, thanks! Now (sorry!), what if I also want the same thing for the cell below? I've copied the code changed the cell reference, and added it, but got an error! Is there a way to accomplish this!? Thanks again...

 

[giacomo]

On 2002-02-25 12:40, Anonymous wrote:
giacomo,

Great- it worked, thanks! Now (sorry!), what if I also want the same thing for the cell below? I've copied the code changed the cell reference, and added it, but got an error! Is there a way to accomplish this!? Thanks again...

Not sure why that didn't work for you, there were two cell references did you change both?

If you're still having trouble replace whatever you have with the following:

Dim cell
For Each cell In Range("a1:a2")
If cell = Empty Then cell.Value = "Enter Age Here"
Next cell

 

[Guest]

Giacomo, thanks man, worked like $$. I really appreciate it....thanks for not giving up on me!