Userform maximum entries?

[kragster]

Hi,
I have made a userform for a spreadsheet activated by a button. For some reason the userform will only show 12 entries, even though the source has a lot more. Can this be defined anywhere? I cant seem to find it.

 

[Loomah]

hi
no matter who gives you a full and final answer to this i'd guess a little more info will be required
eg
12 entries in what? listbox, combo box etc?
where is the source?
how is the whatever it is populated - code or reference to a range?

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[kragster]

Hi,
It is using listbox. The source is a column from another worksheet. It is populated by a reference to that column. Hope that helps.

 

[SkipVought]

What is the ListFillRange reference in your listbox?

Skip,

_[red][/red]

 

[kragster]

Hi Skip,
Where do I see this? In the properties of the listbox, I can't see a ListFillRange reference.

 

[PHV]

Perhaps a RowSource property ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

"The source is a column from another worksheet"

Is the Property RowSource?

Where is your source column refereced and exactly WHAT did you reference in that property?

Skip,

_[red][/red]

 

[kragster]

Ok this is to hard for me to explain. I used this example to create the listbox and tweaked it a bit to fit my needs. It has almost the exact functionality I need, only I need it to contain more than 12 items:

http://www.lacher.com/examples/lacher07.htm

 

[SkipVought]

HELLO????


Where is your source column refereced and exactly WHAT did you reference in that property?

Skip,

_[red][/red]

 

[kragster]

Hi Skip,
I figured it out. The source column was defined by a list name ranging from a2-a13. I just changed the range of the list. Actually what you were asking me in your last question, I had no answer to