ActiveX ComboBox Issues

[LDale]

I have a ActiveX ComboBox and the box is showing one of the items the list of items. When i try select from the box it flash another box and does nothing.
In design mode i can see and select items in the ComboBox object which then changes the ComboBox. Why can't I just select from the omboBox itself?

 

[Yongle]

Perhaps some of your code is conflicting
- do you have more than one event macro associated with the combobox?

What do you want to do with the selected value from the combobox? (how do you want to use it?)

Here is a simple way to start which is guaranteed to work
- build from there changing one thing at a time, making sure it works before moving on.

To test the code
- click on the combobox
- select an item from the list
- click on any cell in the worksheet
- combobox value returned to message box

Before doing that
1. Add a NEW sheet
2. Place values into range A1:A5 (which is used to populate the combobox)
3. Insert active-x combobox in the sheet(check that it is Combobox1)
4. Place the code below in the SHEET module
5. Make sure that "Design Mode" is not active

Private Sub ComboBox1_GotFocus()
    ComboBox1.List = Me.Range("A1:A5").Value
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    MsgBox ComboBox1.Value, , "Value is:"
End Sub