Putting data into combo boxes - is there a quicker way than this?

[Glove303]

I tend to populate combo boxes with loops, which I know can be inefficient.

An example would be this:

For X = 1 To 31
Me.Example_Combo.AddItem Format(X, "00")
Next X

I also add ranges from a worksheet, such as:

For X = 3 To LastRow
Me.Example_Combo.AddItem Data.Cells(X, 1).Value
Next X


I have a feeling I could use arrays to speed things up, but I have searched and cannot find a good answer. Can anyone help me on this please?

Many thanks,
James.

 

[RoryA]

Is your active sheet a chart sheet?

 

[Glove303]

No, and I even tried it on a new workbook.

I'm using 2010, not sure if that makes any difference.

 

[RoryA]

I haven't got that here to test, but I don't see why it would. Will try it later.

 

[Glove303]

Cheers