Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 28th 09, 02:15 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 1
Default How do I add typing instructions to an Excel cell?

Is there a way to add instructions to a cell and have it appear "in the
background" when the cell is selected, then disappear when text is typed?
For example, "Type last name, press TAB".

  #2   Report Post  
Old May 28th 09, 02:19 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,521
Default How do I add typing instructions to an Excel cell?

Why dont use the comments.

Right click on a cell. Add comments..
--
If this post helps click Yes
---------------
Jacob Skaria


"wjs2ps" wrote:

Is there a way to add instructions to a cell and have it appear "in the
background" when the cell is selected, then disappear when text is typed?
For example, "Type last name, press TAB".

  #3   Report Post  
Old May 28th 09, 02:29 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,521
Default How do I add typing instructions to an Excel cell?

For auto hide and unhide. Right click on the sheet tabView Code and paste
the below code. Change the range accordingly. The below works in A1:J30 range.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Target, Range("A1:J30")) Is Nothing Then
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
If Not Target.Comment Is Nothing Then
Target.Comment.Visible = True
End If
End If
End Sub

PS: Set the Security level to low/medium in (Tools|Macro|Security).

If this post helps click Yes
---------------
Jacob Skaria


"wjs2ps" wrote:

Is there a way to add instructions to a cell and have it appear "in the
background" when the cell is selected, then disappear when text is typed?
For example, "Type last name, press TAB".

  #4   Report Post  
Old May 28th 09, 03:31 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,942
Default How do I add typing instructions to an Excel cell?

Data validation will do the trick.
Data - Validation - Input Message - Add your Text and you are done...
--
HTH...

Jim Thomlinson


"wjs2ps" wrote:

Is there a way to add instructions to a cell and have it appear "in the
background" when the cell is selected, then disappear when text is typed?
For example, "Type last name, press TAB".



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 - Nothing shows up in the cell while I'm typing! TomO Excel Discussion (Misc queries) 2 May 14th 08 01:35 AM
click on cell and get instructions, how do you set it up? Ellie05il Excel Discussion (Misc queries) 2 September 13th 07 03:39 PM
typing the date in a cell in excel and ###### comes up instead Lisa Excel Discussion (Misc queries) 6 August 9th 07 01:00 AM
Excel : while typing the Enter key, it does not move to the cell b Raphael Excel Discussion (Misc queries) 1 June 1st 07 03:19 PM
can excel choose a name from a list when I am typing in a cell madisonville Excel Worksheet Functions 1 June 28th 06 03:28 AM


All times are GMT +1. The time now is 04:35 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017