形式的相对定位 [英] relative positioning of forms

问题描述

在Excel 2003中，我正在尝试自动（通过简单地点击命令按钮）在工作表上添加一个相对于工作表位置的VBA表单，无论工作表在何处屏幕上显示。 
例如，我能够获取Excel应用程序窗口  top 坐标与"Application.top"，但无法获取工作表的顶部坐标（比应用程序窗口顶部坐标大约80个像素） 。）  I
已尝试"VisibleRange"，"ActiveWindow"和 "ActiveSheet"，但未成功。 我确信必须有一个我遗漏的简单陈述或命令。 

 

解决方案

对于VBA，Office（VSTO），宏和VBScript问题

http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/c147bae1-c9db-4ae8-9557-43713004cc94

In Excel 2003, I am trying to automatically (through a simple click of a command button) superimpose a VBA form on a worksheet relative to the worksheet's position regardless of where the worksheet is displayed on the screen.  For example, I am able to acquire the Excel application window top coordinate with "Application.top", but am unable to acquire the worksheet's top coordinate (which is roughly 80 pixels greater than the application window top coordinate).  I have tried "VisibleRange", "ActiveWindow", and "ActiveSheet" without success.  I am sure that there must be a simple statement or command that I am missing. 

 

解决方案

For VBA, Office (VSTO), Macros and VBScript Questions

http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/c147bae1-c9db-4ae8-9557-43713004cc94

这篇关于形式的相对定位的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！