[VBA][请教]如何用代码创建窗体,并在窗体中添加按钮等控件?
请问如何用代码创建窗体,并在窗体中添加按钮等控件??我也再找啊
希望高手赐教
有难度 或者怎样在已有的窗体中 用代码创建控件 ?有什么方法吗,各位?
VBA帮助里就有例子:
Dim Mycmd As Control
Private Sub CommandButton1_Click()
Set Mycmd = Controls.Add("Forms.CommandButton.1", "CommandButton3", Visible)
Mycmd.Left = 18
Mycmd.top = 150
Mycmd.Width = 175
Mycmd.Height = 20
Mycmd.Caption = "非常有趣。" & Mycmd.Name
End Sub
Private Sub UserForm_AddControl(ByVal Control As MSForms.Control)
Label1.Caption = "控件已被添加。"
End Sub
页:
[1]