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

On Jul 6, 11:38 am, ACFalcon <ACFal...@discussions.microsoft.com>
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).

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" <(E-Mail Removed)> wrote in message
news:41200D6F-79E3-4E74-9C5F-(E-Mail Removed)...
>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