I'm trying to populate a combobox (in excel using vba) which ad items from a range.
It's doing that.
But when I click an item from the dropdown list, it's not showing any item as it's text. (it's text is blank)
If i ad a code to display a msgbox (with anything) in the click event, it's showing the selected item in the combobox!!
The code I used are below:
Private Sub ComboBox1_DropButtonClick()
For i = 1 To 5
ComboBox1.AddItem Worksheets("Sheet1").Range("a" & i)
Private Sub ComboBox1_Click()
The msgbox is not required and I can find no reason of this behavior.
can any one pls help me..