PC Review


Reply
Thread Tools Rate Thread

Coordinates of Cell

 
 
=?Utf-8?B?QUNGYWxjb24=?=
Guest
Posts: n/a
 
      6th Jul 2007
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
 
Reply With Quote
 
 
 
 
carlos_ray86@hotmail.com
Guest
Posts: n/a
 
      6th Jul 2007
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).

 
Reply With Quote
 
Andy Pope
Guest
Posts: n/a
 
      6th Jul 2007
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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get cell coordinates? lukus2005@gmail.com Microsoft Excel Discussion 3 25th Nov 2009 08:50 PM
XY coordinates to cell address? is it possible SpeeD Microsoft Excel Programming 2 28th Sep 2009 05:34 PM
Cell that is below given coordinates =?Utf-8?B?TXJU?= Microsoft Excel Programming 2 10th Sep 2006 08:21 PM
UDF cell coordinates bve@spe.be Microsoft Excel Programming 2 18th Oct 2005 10:04 AM
Cell coordinates J. Vandenberg Microsoft Excel Discussion 1 31st Jul 2004 05:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:00 AM.