Copy string array to Combobox list 1

[paulbent]

Is there a way using API functions to populate a VB combobox list from a string array?

A combobox in another product I program with has a SetList method which does this. It's way faster than AddItem.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[DrJavaJoe]

I was browsing Devx just yesterday and saw this.

http://www.devx.com/vb2themax/Tip/18996

"Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'."

 

[strongm]

The Forms 2.0 combobox can be populated straight from an array...

 

[paulbent]

Thanks for the link, I'll check it out tomorrow and do some time comparisons.

I see the example uses SendMessage to add the items one at a time. I was wondering if there is a way to copy the array in one go.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[paulbent]

Strongm,

Thanks but I want to be able to port the solution to a LotusCombobox in another environment. It's very similar to a VB combobox and the development environment is similar to VBA. If I can get something working with a VB combobox I should be OK in Lotus.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[paulbent]

DrJavaJoe,

Thought you might be interested... I tested with SendMessage and it was way faster. Loading 6,500 customer names into an unbound LotusCombobox from a recordset took:

AddItem with combo visible: 15.03 secs
AddItem with combo invisible: 10.08 secs
SendMessage: 1.79 secs

Not bad eh? Thanks!

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[DrJavaJoe]

Impressive, good to know.

"Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'."