Cell Address of Mouse Pointer

[Dionysos]

I have a coworker who claims that in an older version of Excel (currently 2007), she was able to identify the location of the mouse pointer (cell address) as she moved it around the worksheet. I don't think she means a mouseover description displaying the cell address, but rulers along the top and sides that would have indicators which you could easily identify the row/column without having to click the cell. Does anybody have any insight into how to get these rulers to display?

[FDibbins]

I know you can do that in powerpoint, but i have nevr seen that in any version of excel

[Jack in the UK]

cells in PowerPoint?

Intresting

[Jack in the UK]

Its API code credit to the author -- have fun

Please Login or Register  to view this content.

To activate the code, run the "StartTimer" macro and to stop it, run the "StopTimer" macro.

[Dionysos]

I know you can do that in powerpoint, but i have nevr seen that in any version of excel

I checked out this functionality in PowerPoint and it looks to be exactly what she described. I'm wondering if she has her applications mixed up because I certainly have never used, or seen, a feature like this in Excel.

p.s. I tried the VBA route and I couldn't get the code to work, plus she want's this functionality to work universally across all spreadsheets.

[FDibbins]

to jack....i didnt mean there are cells in PP, just that you can set PP up to show where the pointer is in the top and bottom margins

[Jack in the UK]

Code work perfectly and shows the mouse CELLs lcation in cell A1....

This is a good start, why does the code not work for you, follow my instuctions as to where to put the codes

ie some in the standard module, some in the worksheet module

[royUK]

Maybe this. It highlights the row, but could easily be adapted

[Jack in the UK]

Maybe replace this bit code as makes easier to read in cell A1

Please Login or Register  to view this content.

[Jack in the UK]

Ermm re RE tested and yes the code works on all worksheets in the workbook and reports to cell A1 each times

Not sure what You are doing incorectly

[Jack in the UK]

Or you could change destination cell A1 to status bar read out and cancel on exit ie

Use this code to take control of the status bar

Please Login or Register  to view this content.

And add this code to cancel on exit or stop which will give control of the statusbar back to the programme

Please Login or Register  to view this content.

[Dionysos]

Jack,

Code looks good. For whatever reason the font color in A1 matched the background and therefore was not apparent. I think this is good if A1 is always viewable. I may be able to work with royUK's code. Thanks for all the contributions. I'll mark this solved.

[Jack in the UK]

Yes agreed so see the post above re status bar ... that would work even better