View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Find tool and cursor

An arrow may be a bit of an ask but try right-clicking the worksheet tab,
view code and then paste this in and see what happens. You should get the
search cell highlighted. In fact the active cell will always be highlighted.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static LastCell As Range
Target.Interior.ColorIndex = 3
LastCell.Interior.ColorIndex = xlColorIndexNone
Set LastCell = Target
End Sub

Mike

Mike

"Joe" wrote:

When looking for something in the spreadsheet with Crl+F I wouuld like to get
a short of an arrow or pointer to help me to identify the cell. Do u know of
any trick?
Thanks,
jose