Check value selected in a ComboBox

[antares63]

Hi,
I have the necessity to include in a only one macro this code

'INITIALIZE text of ComboBox
ThisWorkbook.Sheets(1).ComboBox1.Text = "Select a value"

'ADD 2 values in a conbobox
item = 1
ThisWorkbook.Sheets(1).ComboBox1.AddItem item
item = 2
ThisWorkbook.Sheets(1).ComboBox1.AddItem item

< now I need to select a value in my Sheet1 >

'TEST the value selected
If ThisWorkbook.Sheets(1).ComboBox1.Value = 2 Then
MsgBox "OK!!"
Else
MsgBox "NOT OK!!"
End If

But I receive always the "NOT OK!!" message.

Any Idea?

Thanks in advance.

Giovanni

 

[viper]

are you sure you are getting two value's? You are showing this

item = 1
combobox.additem item
item = 2
combobox.additem item

looking at that it looks to me as though either you are only getting one choice or the same choice.

I ran your code and it worked fine. But instead of adding the items I made a list: in cell b2 I put Select a value, b3 I put 1 and b4 I put 2.

I right clicked on the combobox chose properties and in the ListFillRange I put B2:B4.

Got both messages.