Solved: (location) inside of the combobox

[white_flag]

good morning

I have an combobox with some text values inside. It is possible to find position(location) inside of the combobox on teh text value?

ex.
if
combobox1 = (location1) then Formula1
combobox1 = (location2) then Formula2
...

etc

[Bob Phillips]

Why not just test the value



With Me.Combobox1

If .Value = "Value1" Then

action1
ElseIf .Value = "Value2" Then

action2
'etc

End If
End With

[white_flag]

thx xld


With Me.ComboBox1
If .ListIndex = "0" Then
Cells(10, strLastCol + 1).Value = "=" & ActiveCell.Offset(1, 0).Address(True, False) & "*" & ActiveCell.Offset(2, 0).Address(True, False)
End If

etc...
End With

[Bob Phillips]

If you are going to test ListIndex (which I think is a bad idea, value is better), it is a number so don't enclose the value in quotes.

[mdmackillop]

Why not
Private Sub ComboBox1_Click()
Select Case ComboBox1.ListIndex
Case 1
'do stuff
Case 2
'do stuff
Case 3
'do stuff
End Select
End Sub

[white_flag]

thx mdmackillop and xld

Select Case is a better choice.