Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
The reason I am posting a new topic is because the thread where I'd like to ask this question is about 2 month old, hence I cannot do it there. I only hope that those who were posting to the thread http://groups.google.com/group/micro...5d146a1df45c75 will look here too. However maybe somebody else could help me with this. In that thread the question was how to get the screen coordinates of a Range. And the solution was in using PointsToScreenPix*elsX and PointsToScreenPix*elsY functions. Now my problem here is that when I use this functions they are not returning what I expect them to. For example if I get the screen coordinates of Cell A1 and put there a user form, I was expecting that the userform top left point will be at the top left of A1 cell. But it is positioned a little lower and to the right. If I change the position of the whole excel window and run the same macros, I expected that this behaviour will be repeated, but now the form is displayed lower and more to the right than the previous one - it looks like some coefficient is multiplied. I don't understand this, especially when I see from the posts I refered to above that they didn't have this problem So did anybody see this kind of behaviour from those functions? Is it possible that it is because of 2003 excel which I am currently using? Or what am I missing here? I really need help.. :( Regards, M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
X and Y Screen Coordinates of a Range !!! | Excel Programming | |||
Cell address nearest to screen coordinates | Excel Programming | |||
getting coordinates of a range | Excel Programming | |||
determining coordinates for screen placement of user form | Excel Programming | |||
Screen Coordinates of a given cell in XL | Excel Programming |