User Form ListBox error 381 "could not set the list property"

[karmapala]

Please Login or Register  to view this content.

The named range "PAID" is a dynamic range.
There is no error if this named range has more than one row (where each row has a value),
which in other words, the ListBox1 is populated without error.

But if this named range has only one row (with value),
it throw me an error 381 "could not set the list property".

I've tried something like this :

Please Login or Register  to view this content.

And it still gives me an error, this time Error 1004 "method range of object global failed".

How do I resolve the problem ?

Any kind of respond would be greatly appreciated.
Thank you in advanced.

[karmapala]

For the time being, I tried another code like this

Please Login or Register  to view this content.

Although now it doesn't give me an error,
(in other words, the ListBox is populated without error although the named range is only one row),
but I'm not so sure whether the code is correct.

Thank you.

[torachan]

Try this, put your data in column 'A' row 2 downwards.
I could not understand why you were using Transpose or List ?????
torachan.

Please Login or Register  to view this content.

[karmapala]

Hi torachan,
Thank you for your respond.

I could not understand why you were using Transpose or List ?????

Because the code I make is just copy paste from the code I found in the internet, torachan.

Thank you for your code.
It worked very well.