VBA：在运行时将TextBox添加到UserForm [英] VBA: Add TextBox to UserForm on Runtime

问题描述

我想在运行时添加文本框到我的用户窗体。
目前我正在使用以下代码：

I want to add textboxes on runtime to my user form. Currently I am doing this with this code:

Dim edtBox_n As Control
Set edtBox_n = usrFrm.Controls.Add("Forms.TextBox.1", "edtBox_n", True)
With edtBox_n
    .Top = 20
    .Left = 20
End With

但是，我无法处理多行，最大长度等文本框特定的文字。

However, I cannot manipulate textbox specific porperties like multiline, maxtext length etc.

是否有另一个选项在运行时添加控件到不具备此要求的用户？

Is there another option adding controls on runtime to a userfor which does not lack this requirement?

推荐答案

对于我来说（在Excel 2007中测试）完美无缺：

This works perfectly OK for me (tested on Excel 2007):

Dim edtBox_n As Control
Set edtBox_n = usrFrm.Controls.Add("Forms.TextBox.1", "edtBox_n", True)
With edtBox_n
    .Top = 20
    .Left = 20
    .MultiLine = True
    .EnterKeyBehavior = True
    .Height = 100
End With

这篇关于VBA：在运行时将TextBox添加到UserForm的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！