![]() |
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 |
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). |
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