ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Screen Coordinates of a given cell in XL (https://www.excelbanter.com/excel-programming/279609-screen-coordinates-given-cell-xl.html)

hglamy[_2_]

Screen Coordinates of a given cell in XL
 
Hello,

is there a way to know the "position" of a clicked cell
in terms of screen coordinates ?

Thank you in advance,

Kind regards,

H.G. Lamy



Tom Ogilvy

Screen Coordinates of a given cell in XL
 
In terms of the values that Excel uses,

ActiveCell.Top
ActiveCell.Left

This page on positioning a userform on Chip Pearson's site may provide some
of the insights you are looking for

http://www.cpearson.com/excel/FormPosition.htm

--
Regards,
Tom Ogilvy


"hglamy" wrote in message
...
Hello,

is there a way to know the "position" of a clicked cell
in terms of screen coordinates ?

Thank you in advance,

Kind regards,

H.G. Lamy





hglamy[_2_]

Screen Coordinates of a given cell in XL
 
Thank you, Tom.

I had a look at Chip's Form Positioner,
and try to adapt it to my Agent Positioning.

Kind regards,

H.G. Lamy

"hglamy" schrieb im Newsbeitrag
...
Hello,

is there a way to know the "position" of a clicked cell
in terms of screen coordinates ?

Thank you in advance,

Kind regards,

H.G. Lamy






All times are GMT +1. The time now is 04:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com