Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show Comment when in the cell
Is it possible to make a comment appear when the keyboard cursor goes
to that particular cell instead of mouse moving on to the cell? Manju |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show Comment when in the cell
This one will toggle it on and off with each selection of the cell.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) On Error Resume Next If ActiveCell.Comment.Visible = True Then ActiveCell.Comment.Visible = False Else ActiveCell.Comment.Visible = True End If End Sub hth Vaya con Dios, Chuck, CABGx3 "Manju" wrote in message ps.com... Is it possible to make a comment appear when the keyboard cursor goes to that particular cell instead of mouse moving on to the cell? Manju |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show Comment when in the cell
Put this in worksheet code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim cmt As Comment Set cmt = Target.Comment If cmt Is Nothing Then Exit Sub End If Target.Comment.Visible = True End Sub now both cursor keys and MouseOver will make a comment visible. -- Gary''s Student gsnu200703 "Manju" wrote: Is it possible to make a comment appear when the keyboard cursor goes to that particular cell instead of mouse moving on to the cell? Manju |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show Comment when in the cell
You can also show messages by adding data validation to a cell
Select the cell, and choose DataValidation On the Input Message, enter a title and the message. Click OK There's a bit more information he http://www.contextures.com/xlDataVal04.html Manju wrote: Is it possible to make a comment appear when the keyboard cursor goes to that particular cell instead of mouse moving on to the cell? Manju -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show Comment when in the cell
On Feb 3, 9:43 pm, Debra Dalgleish wrote:
You can also show messages by adding data validation to a cell Select the cell, and choose DataValidation On the Input Message, enter a title and the message. Click OK There's a bit more information he http://www.contextures.com/xlDataVal04.html Manju wrote: Is it possible to make a comment appear when the keyboard cursor goes to that particular cell instead of mouse moving on to the cell? Manju -- Debra Dalgleish Contextureshttp://www.contextures.com/tiptech.html Thanks Debra, That is exactly what I needed. Thanks to others also. But I slightly fear from using VB Code. Thanks to all Manju |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show Comment when in the cell
You're welcome! Thanks for letting me know that it helped.
Manju wrote: On Feb 3, 9:43 pm, Debra Dalgleish wrote: You can also show messages by adding data validation to a cell Select the cell, and choose DataValidation On the Input Message, enter a title and the message. Click OK There's a bit more information he http://www.contextures.com/xlDataVal04.html Manju wrote: Is it possible to make a comment appear when the keyboard cursor goes to that particular cell instead of mouse moving on to the cell? Manju -- Debra Dalgleish Contextureshttp://www.contextures.com/tiptech.html Thanks Debra, That is exactly what I needed. Thanks to others also. But I slightly fear from using VB Code. Thanks to all Manju -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I link the text in a cell into a comment box? | Excel Discussion (Misc queries) | |||
Conditional statements: how do I make reslts show up in dif cell | Excel Worksheet Functions | |||
Can a formula find a comment in a cell | Excel Worksheet Functions | |||
Shortcut key for displaying the active cell comment | Excel Discussion (Misc queries) | |||
Want #VALUE! to show as blank cell | Excel Worksheet Functions |