Thanks Chip
That is why I am not an MVP, LOL. I would have figured it out if I had
tested the code before posting it.


"Chip Pearson" wrote:

For i = 1 To ComboBox1.ListCount - 1

The i variable should start at 0 not 1.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Wed, 17 Dec 2008 08:31:03 -0800, Mike
wrote:

Try this
Private Sub CommandButton1_Click()
For i = 1 To ComboBox1.ListCount - 1
MsgBox Me.ComboBox1.List(i)
Next
End Sub

"inungh" wrote:

I would like to iterate combo box to get all result in a loop.

I try to use cmbMyCombo.count, but Excel does not support the
property.

Are there any property that I can access for this iterate combo box?

Your information is great appreciated,