使用用户输入自动调整文本框大小
The following example demonstrates the effects of the AutoSize property with a single-line TextBox and a multiline TextBox. The user can enter text into either of the TextBox controls and turn AutoSize on or off independently of the contents of the TextBox. 此代码示例还使用 Text 属性。
若要使用本示例,请将此示例代码复制到窗体的"脚本编辑器"中。 若要运行本代码,需要打开该窗体,以便激活 Open 事件。 确保该窗体包含:
两个名称分别为"TextBox1"和"TextBox2"的 TextBox 控件。
一个名为"ToggleButton1"的 ToggleButton 。
Dim ToggleButton1
Dim TextBox1
Dim TextBox2
Sub Item_Open()
Set ToggleButton1 = Item.GetInspector.ModifiedFormPages("P.2").ToggleButton1
Set TextBox1 = Item.GetInspector.ModifiedFormPages("P.2").TextBox1
Set TextBox2 = Item.GetInspector.ModifiedFormPages("P.2").TextBox2
TextBox1.Text = "Single-line TextBox. Type your text here."
TextBox2.MultiLine = True
TextBox2.Text = "Multi-line TextBox. Type your text here. Use SHIFT+ENTER to start a new line."
ToggleButton1.Value = True
ToggleButton1.Caption = "AutoSize On"
TextBox1.AutoSize = True
TextBox2.AutoSize = True
End Sub
Sub ToggleButton1_Click()
If ToggleButton1.Value = True Then
ToggleButton1.Caption = "AutoSize On"
TextBox1.AutoSize = True
TextBox2.AutoSize = True
Else
ToggleButton1.Caption = "AutoSize Off"
TextBox1.AutoSize = False
TextBox2.AutoSize = False
End If
End Sub
支持和反馈
有关于 Office VBA 或本文档的疑问或反馈? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。