当然可以。
Private Sub TextBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
If Button = 2 Then
With Application.CommandBars.Add("Dicky", 5)
With .Controls.Add(1)
.Caption = "复制"
.OnAction = "AAA"
End With
.ShowPopup
.Delete
End With
End If
End Sub
给你看一下 蓝色幻想的一个程序事例 ,代码放窗体的加载程序里面Sub 添加快捷菜单()
Dim mypup As CommandBar
Dim com As CommandBarButton
Dim x
删除命令
Set mypup = Application.CommandBars.Add(Name:="ABC", Position:=msoBarPopup)
For x = 1 To 4
Set com = mypup.Controls.Add
com.Caption = Choose(x, "兰色幻想", "小妖", "小佩", "展翅")
'这4个是加的按钮的名字, 可以改成你自己的, 比如复制粘贴等
com.FaceId = 17 + x
com.OnAction = "A"
'这句是指定的宏的名字, 可以改成你自己的宏, 比如复制 ,粘贴功能宏
Next x
End Sub
Sub 删除命令()
Application.CommandBars("ABC").Delete
End Sub
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)