Private Sub UserForm_Initialize()
Dim myBar As CommandBar
Set myBar = CommandBars.Add(Name:="Custom", Position:=msoBarPopup, Temporary:=False)
With myBar
.Controls.Add Type:=msoControlButton, ID:=3
.Controls.Add Type:=msoControlComboBox
.Controls(2).AddItem "是不是这样"
End With
End Sub
'右击窗体弹出菜单
Private Sub UserForm_MouseUp(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
If Button = 2 Then
CommandBars("Custom").ShowPopup
End If
End Sub
Private Sub UserForm_Terminate()
CommandBars("Custom").Delete
End Sub
Set myBar = CommandBars _
.Add(Name:="Custom", Position:=msoBarPopup, Temporary:=False)
With myBar
.Controls.Add Type:=msoControlButton, Id:=3
.Controls.Add Type:=msoControlComboBox
End With
myBar.ShowPopup