ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Coordinates of Cell (https://www.excelbanter.com/excel-programming/392810-coordinates-cell.html)

ACFalcon

Coordinates of Cell
 
I have a vba form that I want to position over particular cells when they are
selected. How can I get the x,y coordinates of a particular cell in
reference to the screen?

Thanks,
ACFalcon

[email protected]

Coordinates of Cell
 
On Jul 6, 11:38 am, ACFalcon
wrote:
I have a vba form that I want to position over particular cells when they are
selected. How can I get the x,y coordinates of a particular cell in
reference to the screen?

Thanks,
ACFalcon


This might help. Every cell has a position Column A=1 B=3 C=4 etc. and
then Rows are numbered already the syntacs is Cells(row,column).


Andy Pope

Coordinates of Cell
 
Hi,

Have a look at Chip Pearson's page on the subject.
http://www.cpearson.com/excel/FormPosition.htm

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"ACFalcon" wrote in message
...
I have a vba form that I want to position over particular cells when they
are
selected. How can I get the x,y coordinates of a particular cell in
reference to the screen?

Thanks,
ACFalcon




All times are GMT +1. The time now is 01:57 AM.

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