vba 如何制作可调整大小的 UserFrom？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/27235870/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to make a resizable UserFrom?
提问by Jacobian
I do not know how to make the simplest in the world resizable UserForm. What I have seen on different forum threads are terrible behemots (huge as the Universe libraries doing too much). But I need a simple, one stroke solution and I hope it exists. At this moment I have this code:
我不知道如何制作世界上最简单的可调整大小的用户窗体。我在不同的论坛帖子上看到的都是可怕的庞然大物（因为 Universe 库做得太多了）。但我需要一个简单的一次性解决方案，我希望它存在。此时我有这个代码：
Dim myForm As UserForm1
Set myForm = New UserForm1
myForm.Caption = "Attributes"
myForm.Show
And I have UserForm_Initialize()which does some extra work. What is horrible (unreasonable?) is that by default a form is not resizable.
我有UserForm_Initialize()它做了一些额外的工作。可怕（不合理？）是默认情况下表单不可调整大小。
回答by Mana
Here's a simple guide on how to make a userform drag and re-sizable.
这是有关如何使用户表单拖动和重新调整大小的简单指南。
http://www.mrexcel.com/forum/excel-questions/558649-userform-movable-resizable.html
http://www.mrexcel.com/forum/excel-questions/558649-userform-movable-resizable.html
