list box multivalues retrieval

[questionit]

I have a List Box with multi-select option = "Extended".

how can i retrieve all the selected values into a variable/array variable

i have tried but cant do like List4.Value(1) ..


help please

Thanks

[Killer42]

I have a List Box with multi-select option = "Extended".
how can i retrieve all the selected values into a variable/array variable
i have tried but cant do like List4.Value(1) ..

I believe one of the properties returns an array of booleans corresponding to the list. Um... I think the property is called .Selected. If so, you would use an array or something to check ListBox.Selecte d(n). Have a look through the properties anyway, you shouldn't have any trouble finding it.

[questionit]

I am keep on getting error : "Invalid use of Null" - only if i select any value afer the first one in List Box

Dim nA() As String
Dim c As Integer
c = 1
 For n = 1 To List21.ListCount
   If List21.Selected(n) Then
     nA(c) = List21.Value
      MsgBox (nA(c))
         c = c + 1
   Else
   End If

Any idea whats wrong.
Thanks

I believe one of the properties returns an array of booleans corresponding to the list. Um... I think the property is called .Selected. If so, you would use an array or something to check ListBox.Selecte d(n). Have a look through the properties anyway, you shouldn't have any trouble finding it.

[Killer42]

Not sure whether it's the problem, but try changing line 4 to "For n = 0 To List21.ListCoun t - 1". VB has this rather annoying tendency to begin all its arrays at zero, which means they actually end one place earlier than you expect.

In other words, if there are 10 items in the list, they are actually numbered from 0 to 9, not 1 to 10 as any reasonable person would expect. But the ListCount will be 10, because it's simply the number of entries.

[Killer42]

One more thing. You didn't say which line produced the error. But just form what you posted, I don't think the array nA() has any occurrences. You haven't defined anywhere what size it is. Not sure whether that's a problem (may depend on your option settings) but it doesn't look right to me.

[questionit]

I am gettin error on this line:

nA(c) = List21.Value

This works fine with my VB
Dim nA() As String

but i also have tried with this:
Dim nA(10) As String

but still the same error comes "Invalid use of Nll Error 94" The strange thing is if i select first value in list box, i never get any error but only with other values?

One more thing. You didn't say which line produced the error. But just form what you posted, I don't think the array nA() has any occurrences. You haven't defined anywhere what size it is. Not sure whether that's a problem (may depend on your option settings) but it doesn't look right to me.

[questionit]

one more strange thing:

Dim p As String

p = List21.Value -- error line

MsgBox p

now only on this code, i get error 94 "invalud use of Null" i cant figure out why

I am gettin error on this line:

nA(c) = List21.Value

This works fine with my VB
Dim nA() As String

but i also have tried with this:
Dim nA(10) As String

but still the same error comes "Invalid use of Nll Error 94" The strange thing is if i select first value in list box, i never get any error but only with other values?

[Killer42]

I think the whole problem may revolve around your use of the .Value property. In my experience (up to VB6) the listbox control doesn't have a Value property. The values in the list have always been accessed through the .List() array property.

[questionit]

List does have .Value propertyas i am using VBA.

But this is my code , which keeps on giving error and the statement in Else Clause is being executed all the time even though i select items in the List:

For n = 0 To List21.ListCoun t - 1
If Me.List21.Selec ted(n) = -1 Then
nA(c) = List21.Value
'MsgBox (Me.List21.Valu e)
'c = c + 1
Else: MsgBox "nothing selected"
End If
Next n

any other clue?

I think the whole problem may revolve around your use of the .Value property. In my experience (up to VB6) the listbox control doesn't have a Value property. The values in the list have always been accessed through the .List() array property.

[Killer42]

I don't get it. If this is a list, in which multiple items can be selected, then what exactly does the .Value property represent?