Excel VBA: Set number of items to display in userform listbox

[vikingatc]

I've got a listbox that gets its values from a range on an associated worksheet. The range size varies on a search result. The problem is this: if the results returns, say, 5 items the first time it is run, the box will display the 5 items just fine. If the next result is more than 5 items, it will display only the first 5 items in the listbox. The range ont he worksheet resizes correctly each time, but the box display seems "locked" on the first number it gets. I just can't seem to find a property to set to correc this. Any suggestions?

Thanks

 

[PHV]

Have a look at the RowSource property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vikingatc]

Thanks, but I've exhausted all the normal resources. No one seems to be able to track down this problem. There is no property to set for rows displayed, strange, but true. When I reload the form, the box will show all the results, until the above-described situation results again. very strenge. thanks, though.

 

[PHV]

Straight from the VBA help:
ListBox1.RowSource = "a1:e4"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vikingatc]

thanks for your help. The problem persists and I suspect it is likely user error 8). Thanks for your time and for the help.