Active Cell Screen Coordinates - Not Mouse Coordinates

[mkclhr]

Hi, I am trying to find the screen coordinates (top and left) of the active cell. The mouse can be anywhere else on the screen. I can get the active cell's "top and left" coordinates from the cell properties, but these coordinates are relative to the Excel application window - and that's not what I am looking for. I searched through the posts but was unable to find posts related to this.

Thanks,

 

[BrianB]

May be possible depending on circumstances. There are all sorts of things that could screw this up. Like changing column widths. I have, for example, been able to simulate a mouseclick in a cell, which requires knowing the screen coordinates - but I was in control of any sheet changes.

Application.Top and Application.Left will give the Excel screen positions, so you could calculate the cell screen position if you know the difference.

eg. Cell A1 Top and Left are both zero, so, in theory you could use Excel.Left as being the A1 cell Left.

The problem is with Top. If the number of toolbars changes the distance between Application.Top and Cell A1 Top will be different.

You have not said what you are trying to achieve. Perhaps there isanother way.

 

[mkclhr]

Hi Brian,

Thanks for the reply. I will certainly give this a shot. I was trying to figure out which container (object) would give me the screen coordinates - to the extent I was even now looking at APIs like GetRect, GetFocus etc...

The menu's in the excel application are static, so that should be a constant I can easily factor into the calculation. The Selection property does not recognize custom menu methods hence I was trying to simulate a Right-Click in a cell to force a custom menu command.

BTW - is there a way to enforce triggering a custom menu method using excel's default methods other than having to call the function directly in code?

Regards,
Kashif.

 

[Norie]

The Selection property does not recognize custom menu methods hence I was trying to simulate a Right-Click in a cell to force a custom menu command.

What do you mean?

Are you trying to customize the right click menu?