Populating ComboBox Performance

  • Thread starter Thread starter plutoplanet
  • Start date Start date
P

plutoplanet

Hi
Populating a ComboBox with a String() array of 100 Items takes up to 10
Seconds:
MyComboBox.DataSource = MyStrings
Doing the same within a loop is pretty much faster:
For i = lbound(mystring) to ubound(mystrings)
mycombo.items.add(mystrings(i))
next i
Is there no 3rd way?
Herwig
 
Herwig

The loop technique is substantially faster and there really isnt an
alternative when performance is an issue.

Nick
 
Try setting combo.visible to false before you populate and back to true
after you finish.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

delete code keeps going and coing 5
combobox and string array 3
deleting rows based on criteria 7
Deleting rows 3
Repeated call to InternetExplorer.Application seems to hang the PC 4
Need help with a Custom Function 7
Object variable or with block not set Err 91 2
Populate comboboxes based on query 2

Back
Top