Setting String Array as Combobox List gives Argument is required error in Visual Basic

Question

So I have a String array declared as this:

Dim astrSomethingList() As String: astrSomethingList = _ 
    Array("01", "02", "03", "04", "05", "06", "07", "08", "20")

And then I try to assign this array to a ComboBox I have in a form, like this:

With m_form

    ...
    
    .cboQuerySomething.List = astrSomethingList

    ...
    
End With

But when I try to compile and run it, it gives me the error The argument is not optional and refers to the .List = part of the code.

I have tried using

Set .cboQuerySomething.List = astrSomethingList

instead, but it does not work either.

What am I missing?

You cannot have astrSomethingList = Array(...). You also should consult the documentation for List and/or stackoverflow.com/a/24889461/11683, having established that you are indeed using VB6/A and not VB.NET. — GSerg
– GSerg, Commented Jul 26, 2021 at 10:25
@GSerg Thank you, I will check the documentation first next time. — Biel
– Biel, Commented Jul 26, 2021 at 10:38
It would help if you knew what language you were writing in. Did you read the descriptions of the tags you used? It would seem not, because this cannot be a VB.NET question and a VB6 question. It is either one or the other. Given that a VB.NET ComboBox has no List property, I'm guessing it's VB6. You should know. — jmcilhinney
– jmcilhinney, Commented Jul 26, 2021 at 10:39
@jmcilhinney It is VB6 yes, sorry for the confusion this caused. I am new to VB and did not check the differences before asking, my bad. — Biel
– Biel, Commented Jul 26, 2021 at 10:41

User51 · Accepted Answer · 2021-07-26 18:25:50Z

2

For VB6 Combo Boxes, first call .Clear and then loop through the values and use .Add on each item individually

.List() in a VB6 Combobox is an indexed property, not a settable field. There is no way to set the entire list at once, but it would be simple to create a helper module with commonly executed tasks.

answered Jul 26, 2021 at 18:25

User51

1,14912 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Biel Over a year ago

Thank you! I read the docs later but was still a little bit confused and thought .List() was settable, but I wasn’t doing it right. This helped me a lot.

Collectives™ on Stack Overflow

Setting String Array as Combobox List gives Argument is required error in Visual Basic

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related