vba ,窗体中用代码生成的命令按钮如何去使用它?

private sub userform_initialize()
dim kj as object
set kj=me.controls.add("Forms.Frame.1","我是框架")
kj.caption="框架是我"
kj.left=130
kj.top=50

dim ml as object
set ml=me.controls.add("Forms.CommandButton.1","我是命令按钮")
ml.caption="点我删除框架"
ml.left=30
ml.top=30
end sub

'上面的窗口初始化,用代码生成了一个框架的控件和一个命令按钮的控件,
现在我要用这个命令按钮去删除这个框架,应该怎么去写这个用代码生成的命令按钮的点击应用呢?
反正,下面的代码不行,因为这纯粹是一个新的过程
private sub ml_click()
me.controls.remove “框架是我”

改下面这样

Dim WithEvents ml  As CommandButton ''''注意这里用withevents来申明

Private Sub userform_initialize()
Dim kj As Object
Set kj = Me.Controls.Add("Forms.Frame.1", "我是框架")
kj.Caption = "框架是我"
kj.Left = 130
kj.Top = 50

''dim ml as object'''要按照上面那样申明才行
Set ml = Me.Controls.Add("Forms.CommandButton.1", "我是命令按钮")
ml.Caption = "点我删除框架"
ml.Left = 30
ml.Top = 30
End Sub


Private Sub ml_click()
Me.Controls.Remove ("我是框架")
End Sub


您好,我是有问必答小助手,您的问题已经有小伙伴帮您解答,感谢您对有问必答的支持与关注!
PS:问答VIP年卡 【限时加赠:IT技术图书免费领】,了解详情>>> https://vip.csdn.net/askvip?utm_source=1146287632