Disappearing in-cell instructions

Hello,
Simple question here: I'd like to have a cell contain instructions that disappear when text is entered into the cell, much like the "help" box on the upper right of the Excel window has a label that says "Please type question here", which disappears when you actually type in a question. Any ideas?
THANKS.

Maybe like this. Code goes in the appropriate sheet module.

Please Login or Register  to view this content.

Originally Posted by shg

Maybe like this. Code goes in the appropriate sheet module.

Please Login or Register  to view this content.

Where so I paste this code to make the function work?

In the appropriate sheet module:

Adding Code to a Sheet module
1. Copy the code from the post
2. Right-click on the tab for the relevant sheet and select View Code
3. Paste the code in the window that opens


Please be circumspect about posting questions in other people's threads.

All I want is for the J2:J9 range to display "Paste special" if there is no data in the cells.

Can someone insert the appropriate code in the sheet module?

Hello, unfortunately I can't get this to work. I've tried changing the cell address (I65 is the first target cell in this case). Also, this would be going into a workbook with several sheets, and I'd like this function to appear in each sheet. I tried copying this into the "This Workbook" code view, to no avail. Any ideas?

Post your workbook with the code installed.

Normally, this book has 7 sheets. I shaved 5 off to keep it under 100KB.

Two things: You can see that for the sheet SchlA (Sheet3 in VBA) I was able to get it to work for one cell (K47). However, I'm not sure how to make it apply to the range of cells below it (K47:K63). Lastly, the "comments" text does not appear until after you've typed something and then delete it.

Thanks for all your help, shg.

I'm not sure how to make it apply to the range of cells below it (K47:K63)

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Lastly, the "comments" text does not appear until after you've typed something and then delete it.

You could just add them to the form initially.

That did it. Many thanks.

You're welcome, glad it worked for you.