Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all
The comments appear when I hover over cells, Should they appear when I use the arrow keys? mine don't. I have them set on "Comments indicator only" The reason for this post, Is there a way of showing comments when I use this Macro. Sub Finddown() Dim FoundCell As Range Set FoundCell = ActiveCell.EntireColumn.Find(What:=ActiveCell.Valu e, _ After:=ActiveCell, LookIn:=xlValues, LookAt:=xlWhole, MatchCase:=False) If Not FoundCell Is Nothing Then FoundCell.Select End If End Sub This macro finds the next same value down the column, I also have a Findup macro. Is there a way to showing comments when I use this Macro. Example To work like this Active cell is M4, run macro to find next same value down, lets say M50 which there is a comment, it does not show the comment. only on hover. Thanks in advance Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Arrow Keys | Excel Discussion (Misc queries) | |||
Using arrow keys | Excel Discussion (Misc queries) | |||
Arrow Keys | Excel Discussion (Misc queries) | |||
Arrow Keys | Excel Discussion (Misc queries) | |||
arrow keys | Excel Discussion (Misc queries) |