Find tool and cursor
 

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

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

Find tool and cursor
 

where do I find the worksheet tabview code?

"Mike H" wrote:

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

Find tool and cursor
 

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

"Joe" wrote:

where do I find the worksheet tabview code?

"Mike H" wrote:

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

Find tool and cursor
 

Any otherideas?
Tks

"Joe" wrote:

where do I find the worksheet tabview code?

"Mike H" wrote:

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