Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Worked fine with this code: 'Place code below in the standard module: Sub popupcmb() Dim myBar As CommandBar Dim myBarc As CommandBarButton Dim myBarcb As CommandBarComboBox Set myBar = CommandBars.Add(Name:="custom", _ Position:=msoBarPopup, _ Temporary:=False) Set myBarc = myBar.Controls.Add(Type:=msoControlButton, ID:=1) With myBarc .Caption = "Test Bar name" .OnAction = "Procedure1" End With myBar.ShowPopup myBar.Delete End Sub Sub Procedure1() MsgBox "test" End Sub 'Place code below in the Worksheet module: Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) Cancel = True popupcmb End Sub -- Regards, Halim "diddy_david" wrote: I've created custom a custom menu with various macros, how can I display this as a popup (shortcut) menu when a cell is right clicked? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Popup Menu / Shortcut Menu | Excel Discussion (Misc queries) | |||
Custom Floatable Toolbar Popup Menu | Excel Programming | |||
Adding Sub Menu Item to Current Custom Menu | Excel Programming | |||
Tooltips won't show up in custom popup menu | Excel Programming | |||
Custom Menu return to Excel Menu upon Closing | Excel Programming |