Solved: Check if combo box is populated

Hi, I feel a bit stupid posting this as it seems really simple.

I have a combobox, I want to check if its populated with anything. I check to see if its empty with null that works

Code:

---

If ComboBox1.Value = Null Then
GoTo CarryOn
ElseIf ComboBox1.Value = ?WHATGOESHERE? Then

---

Thanks in advance!

There are a couple of approaches.

[vba]If ComboBox1.Value = "" Then
'More code
end if

If ComboBox1.ListIndex = -1
'More code
end if
[/vba]

Quote:

---

Originally Posted by Tinbendr

There are a couple of approaches.

[vba]If ComboBox1.Value = "" Then
'More code
end if

If ComboBox1.ListIndex = -1
'More code
end if
[/vba]

---

Thanks, but im checking to see if there is actually an entry in the combobox not if its empty, im pretty sure the following do the same thing and only check to see if its empty?

null
-1
""

Maybe im missing something?

That shows if anything has been selected, if you want to know if it has been populated, test the ListCount property.

Quote:

---

Originally Posted by asystole0

. to check if its populated with anything.

---

Oops, my bad. And of course, Xld is correct.

Thanks, Ive attempted to code it as per below example but it doesnt work, any ideas?

Code:

---

If ComboBox1.ListCount = 0 Then
GoTo CarryOn
ElseIf ComboBox1.ListCount = 1 Then

---

Hmm.. Don't rightly know.

This example works on my machine.

[vba]Private Sub UserForm_Initialize()

If ComboBox1.ListCount = 0 Then
MsgBox "List Empty"
End If

With ComboBox1
.AddItem "One"
.AddItem "Two"
.AddItem "Three"
End With

If ComboBox1.ListCount > 0 Then
MsgBox "Combobox1 has " & ComboBox1.ListCount & " entries"
End If

End Sub
[/vba]

Is this a combobox from a form or from the Control Toolbox toolbar?

Is this a combobox from a form or from the Control Toolbox toolbar?

Quote:

---

Originally Posted by xld

Is this a combobox from a form or from the Control Toolbox toolbar?

---

Its a combobox on a form.

Then as Tinbendr says, it should work.