Mouse Position

[Max Potters]

Hi all,

I'm trying to run a code when the mouse pointer comes on a specific range
on, for example, Sheet1. Im trying to run a little macro which shows a
toolbar, when the cursor is on the X, Y ranges of the standard toolbar (when
the cursor moves over the toolbar's position, while the toolbar is not
visible, it makes it visible).

Does anyone know how to do this?

Thanks in advance
Max

 

[Frank Kabel]

Hi
not really possible as there's no event which return the X/Y position
on a spreadsheet. So you'll have to use Windows aPI functions and
CALCULATE the mouse position on your spreadsheet

 

[Bob Phillips]

Max,

Take a look at the RangeFromPoint method in help.

 

[Guest]

hi,
not really possible to do that.
but you might be able to play tricks.
Put a label control on the range somewhere. you can then
use the label controls mouse move event.