Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 67
Default 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).

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,489
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell that is below given coordinates MrT Excel Programming 2 September 10th 06 08:21 PM
Convert point coordinates - pixel coordinates Zorro[_3_] Excel Programming 1 June 1st 06 03:26 AM
Simple way to convert UTM ED50 coordinates to decimal coordinates? Dan[_38_] Excel Programming 8 July 11th 04 04:54 PM
Converting MouseDown Coordinates to Chart Point Coordinates Steve[_50_] Excel Programming 3 December 2nd 03 06:48 PM
Screen Coordinates of a given cell in XL hglamy[_2_] Excel Programming 2 October 15th 03 02:03 PM


All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"