Coordinates of Cell

[Guest]

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

 

[carlos_ray86]

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]

Hi,

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

Cheers
Andy