Combobox load - how to speed it up?

[Oliver Dewar]

Hi All.

I have a userform with a combobox from which the user can select any suburb in a certain country.

When the form loads it populates this combobox by VBA.

Depending on how far down the list the suburb is, this action can take a second or two and slows the form load down more than anything else.

Does anyone have any vba techniques to speed up combobox loading?

Please explain everything as if I'm totally new and thick... because I am (thick at least) .

 

[erik.van.geit]

Hallo
Please provide your code, so someone can ammend it.

kind regards,
Erik

 

[Oliver Dewar]

Well... not sure if it will illuminate anything much but:

combobox1.value = range("A1").value

Combobox1's row source includes 16500 rows.

 

[Oliver Dewar]

Hang on... hold the phone...

For some reason the load has just sped up massively by itself!

I don't have enough understanding of excel to be able to suggest why this might be... but it's now loading the values in a split second. It was taking one or two seconds before.

Bizarre... but welcome!

 

[erik.van.geit]

You're welcome!
I hope your workbooks health is still OK. From what you posted we can not tell what could be the problem.

 

[Oliver Dewar]

Thanks for coming to help Eric. It seems to be fast and happy now so lets do the three Monkeys and enjoy some ignorance!