Iterate All the List in a Combo Box

For i = 0 To ComboBox1.ListCount - 1
MsgBox ComboBox1.List(i)
Next i

Use ListCount to get the total entries in this ComboBox1

use List(index) to access the current entry