help Compare string to Combo box!!!
 

How would you compare a variable to see if it was in a combobox??
I was Thinking maybe

If Variable = CboBox.Text but wouldnt that only compare it to the one
selected?

help Compare string to Combo box!!!
 

Try something like this:
Dim cnt as long
For cnt = 0 to CboBox.ListCount - 1
If Variable = CboBox.List(cnt) then
'Do Something
Else
'Do Something Else
End If
Next
--
Charles Chickering

"A good example is twice the value of good advice."


" wrote:

How would you compare a variable to see if it was in a combobox??
I was Thinking maybe

If Variable = CboBox.Text but wouldnt that only compare it to the one
selected?