|
本帖最后由 大灰狼1976 于 2024-3-7 21:13 编辑
SetFrameLocation放到标准模块里面,增加一个参数,表示当前userfom
'位置参数设定
- Public Sub SetFrameLocation(UsFm As UserForm, strFrameName As String, sngHeight As Single, sngWidth As Single, sngTop As Single, sngLeft As Single)
- Dim objFrame As Control
- On Error GoTo ErrFun
- Set objFrame = UsFm.Controls(strFrameName)
- With objFrame
- .Height = sngHeight
- .Width = sngWidth
- .Top = sngTop
- .Left = sngLeft
- End With
- ErrFun:
- Set objFrame = Nothing
- End Sub
复制代码
引用示例:
- Private Sub CommandButton3_Click()
- SetFrameLocation Me, "Frame1", 20, 20, 20, 20
- End Sub
复制代码 |
|