Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Right-click Combo Event
Hi there,
I'd like to add a right click context menu ("Delete selected item") to a combobox so that I can right click on an item and remove it from the combobox's source range and the combobox itself. I'm happy with the remove code, but would appreciate help with the right click event. Thanks in advance John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Right-click Combo Event
Seems like you would use the mousedown event and look at the button argument
to see if it is a right click. You could then have the code position a commandbutton or label next to the combobox. -- Regards, Tom Ogilvy "John" wrote in message ... Hi there, I'd like to add a right click context menu ("Delete selected item") to a combobox so that I can right click on an item and remove it from the combobox's source range and the combobox itself. I'm happy with the remove code, but would appreciate help with the right click event. Thanks in advance John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Right-click Combo Event
Perfect. Thanks Tom.
In the end I just used a YesNo MsgBox having got the list item from your MouseDown event. Thanks again John "Tom Ogilvy" wrote in message ... Seems like you would use the mousedown event and look at the button argument to see if it is a right click. You could then have the code position a commandbutton or label next to the combobox. -- Regards, Tom Ogilvy "John" wrote in message ... Hi there, I'd like to add a right click context menu ("Delete selected item") to a combobox so that I can right click on an item and remove it from the combobox's source range and the combobox itself. I'm happy with the remove code, but would appreciate help with the right click event. Thanks in advance John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Click event to run only once | Excel Programming | |||
Click event to run only once | Excel Programming | |||
Click event to run only once | Excel Programming | |||
Before Right Click event | Excel Programming | |||
Click Event | Excel Programming |