| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Tool & Tabbing | Excel Worksheet Functions | |||
| Where do i find the sort tool in Office XP? | Excel Discussion (Misc queries) | |||
| My excell tool/menu bar disappeared and I cant find it or get it | Excel Discussion (Misc queries) | |||
| Using the Find tool in EXCEL | Excel Worksheet Functions | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
Hybrid Mode
