Obtain value of a control on a shortcut menu
 

Could someone please show example code on how to capture what the selected
content (a string) of a combobox was on a shortcut menu when it closed?

Thanks in advance.

Obtain value of a control on a shortcut menu
 

From Rob Bovey:

Sub HandleCombo()

Dim ctlComboBox As CommandBarComboBox
Dim szItem As String

Set ctlComboBox = CommandBars.ActionControl

szItem = ctlComboBox.Text

''' This is required to overcome a screen refresh bug in Excel 97.
Application.ScreenUpdating = False
Application.ScreenUpdating = True

MsgBox "You chose " & szItem

End Sub

--
Regards,
Tom Ogilvy

"quartz" wrote in message
...
Could someone please show example code on how to capture what the selected
content (a string) of a combobox was on a shortcut menu when it closed?

Thanks in advance.