Find tool and cursor

J

Joe

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
 
M

Mike H

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
 
J

Joe

where do I find the worksheet tab>view code?

Mike H said:
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
Click to expand...
 
J

Joe

i found it but it doesnt work the way I want. Thanks anyway. I was trying to
find sort of a pointer
 
Top