Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Userform maximum entries?

Status
Not open for further replies.

kragster

Technical User
May 9, 2007
55
DK
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.
 
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? [ponder]
How do I get the best answers?
 
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.
 
Hi Skip,
Where do I see this? In the properties of the listbox, I can't see a ListFillRange reference.
 
Perhaps a RowSource property ?

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



"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,

[glasses] [red][/red]
[tongue]
 




HELLO????


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


Skip,

[glasses] [red][/red]
[tongue]
 
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 ;)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top