Shortcut Menus

Const PopUpName As String "MyPopUpMenu" 

Sub DeletePopupMenu
   CommandBars(PopUpName).Delete
End Sub

Sub CreatePopupMenu
Dim cb As CommandBar
Dim cbp As CommandBarPopup

   Set cb = CommandBars.Add(PopUpName, msoBarPopup, False, True)
   With cb
      With .Controls.Add(Type:=msoControlButton)
         .OnAction = ""
         .FaceId = 10
         .Caption = ""
         .ToolTipText = ""
       End With

      Set cbp = .Controls.Add(Type:=msoControlPopul
      With cbp
         .BeginGroup = True
          .Caption = "sub menu"
           With .Controls.Add(Type:=msoControlButton)

           End With
           Set cbp = Nothing
      End With
   End With
Set cb = Nothing
End Sub

Sub DisplayPopUp 
   Application.CommandBars(PopUpName).ShowPopup
End Sub

In the Userform code module

Private Sub UserForm_MouseMove(byVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single) 
   if Button = 2 Then
'number 2 is the right mouse button
      Call DisplayPopUp
   End If
End Sub




© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext