VBA to get the selected value from active x combobox control

[ramkumarcn]

Hi,

I am trying to get the selected item from a active x combo box control. Could you please help me with the code?

Thanks,
Ram

 

[Worf]

Hi
It will depend on its location:

'inside UserForm
Private Sub CommandButton1_Click()
MsgBox Me.cb1.Value
End Sub

' sheet control
Sub cbvalue()
MsgBox ActiveSheet.OLEObjects("ComboBox1").Object.Value
End Sub