ListBox List function not allowing column argument when assigned to a variable

[Brunstgnegg]

Hello everyone

I have a weird problem. I have a list box with 4 columns that I wish to assign/read with the List function. If I use the ListBox directly i.e.

ListBox21.List(row, column)

it works. But if I first assign a variable

Set Lst = ListBox21
Lst.List(row, column)

it says it can't find the function, it can however find a function called list with only one argument, i.e. the index for the row.

What am I doing wrong?

Thanks in advance

[romperstomper]

How is Lst declared?

[Brunstgnegg]

How is Lst declared?

Sorry, missed that.

Dim Lst as ListBox

[romperstomper]

That's your problem - it should be:

Dim Lst as MSForms.ListBox

[Brunstgnegg]

That's your problem - it should be:

Dim Lst as MSForms.ListBox

Works Perfectly!

Thanks!