Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using Excel in Office 2000. I need to show a userform that is
positioned with it's top aligned with the top of the second visible row of the active worksheet. It also needs to have it's left side aligned with the left side of the second visible column. It seems userforms use screen offsets, and Excel rows and columns use the Inner offset of the worksheet. How do I translate the row and column coordinates to screen offsets? If the user has Excel not maximized, for example, or if there are custom menu bars which scoot the top of the activesheet down, then it becomes difficult to know what the UserForm coordinates need to be. D Zook |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cursor positioning | Excel Discussion (Misc queries) | |||
Positioning a DOS Window | Excel Programming | |||
UserForm positioning | Excel Programming | |||
help with command bar positioning | Excel Programming | |||
= positioning | Excel Programming |