|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
November 30th, 2008, 02:54 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Number of entries in drop down box
I have a drop down box in my spreadsheet that I use for listing the builders that I work with/for. It appears that the max. number of entries is 12. Can I increase that? -- theslaz ------------------------------------------------------------------------ theslaz's Profile: http://www.thecodecage.com/forumz/member.php?userid=44 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35320 
|
|
#2
November 30th, 2008, 03:48 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number of entries in drop down box
Is it a validation dropdown or a worksheet dropdown or a combobox? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35320
|
|
#3
November 30th, 2008, 03:54 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number of entries in drop down box
I had to check. I believe it is a combo box! -- theslaz ------------------------------------------------------------------------ theslaz's Profile: http://www.thecodecage.com/forumz/member.php?userid=44 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35320
|
|
#4
November 30th, 2008, 04:15 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number of entries in drop down box
If it's a combobox from the control toolbox toolbar, you can go into design mode
(another icon on that control toolbox toolbar), then click the properties icon. Look for ListRows and change it to what you want. If it's a dropdown from the Forms toolbar: Rightclick on it and choose Format Control. On the Control tab, change the drop down lines to what you want. If it's a data|validation dropdown, you're stuck with what excel gives you. theslaz wrote: I had to check. I believe it is a combo box! -- theslaz ------------------------------------------------------------------------ theslaz's Profile: http://www.thecodecage.com/forumz/member.php?userid=44 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35320 -- Dave Peterson
|
|
#5
November 30th, 2008, 05:06 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number of entries in drop down box
Don't know what to say. I tried to check and see what properties the drop down list had and really nothing shows. Yet when I created a "Test" Combo Box and checked it's properties; it was listed as Combo Box 1 and showed all it's settings including the "ListFiles" you mentioned. At a loss as to what to try next in order to determine what in fact this "Combo Box" of mine is! -- theslaz ------------------------------------------------------------------------ theslaz's Profile: http://www.thecodecage.com/forumz/member.php?userid=44 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35320
|
|
#6
November 30th, 2008, 05:40 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number of entries in drop down box
ListRows, not ListFiles.
How many items are in the list? What did you use in the .listrows property? theslaz wrote: Don't know what to say. I tried to check and see what properties the drop down list had and really nothing shows. Yet when I created a "Test" Combo Box and checked it's properties; it was listed as Combo Box 1 and showed all it's settings including the "ListFiles" you mentioned. At a loss as to what to try next in order to determine what in fact this "Combo Box" of mine is! -- theslaz ------------------------------------------------------------------------ theslaz's Profile: http://www.thecodecage.com/forumz/member.php?userid=44 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35320 -- Dave Peterson
|
|
#7
November 30th, 2008, 05:46 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number of entries in drop down box
The properties box looks like this and has a line: List Rows 8 change that: 28 +-------------------------------------------------------------------+ |Filename: combobox properties.jpg | |Download: http://www.thecodecage.com/attachment.php?attachmentid=28| +-------------------------------------------------------------------+ -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35320
|
|
#8
November 30th, 2008, 06:24 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number of entries in drop down box
Sorry; I meant Listrows; and yes I found the properties box and the entry for Listrows which had the number 8. That was when I did the "Test" combo box. Right now I have 17 enteries in the "Builderlist" of which only 12 show. The combo box that I have references to this builderlist; however; as I said; I can not determine how it does that; as when I click on my combo box and then look at it's properties in Design mode; all that shows is the properties for sheet 1 which is named "Invoice Data Entry" -- theslaz ------------------------------------------------------------------------ theslaz's Profile: http://www.thecodecage.com/forumz/member.php?userid=44 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35320
|
|
#9
November 30th, 2008, 07:20 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number of entries in drop down box
When you're in design mode, select the combobox first. Then click the
Properties icon. Then change the .listrows property to something else (17???). theslaz wrote: Sorry; I meant Listrows; and yes I found the properties box and the entry for Listrows which had the number 8. That was when I did the "Test" combo box. Right now I have 17 enteries in the "Builderlist" of which only 12 show. The combo box that I have references to this builderlist; however; as I said; I can not determine how it does that; as when I click on my combo box and then look at it's properties in Design mode; all that shows is the properties for sheet 1 which is named "Invoice Data Entry" -- theslaz ------------------------------------------------------------------------ theslaz's Profile: http://www.thecodecage.com/forumz/member.php?userid=44 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35320 -- Dave Peterson
|
|
#10
November 30th, 2008, 11:44 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number of entries in drop down box
I've determined that it is not a Combo Box from the Control Toolbox tool bar. It is a dropdown from the forms toolbar. I have changed the number of lines it will display. It appears to be working! Thanks for your trouble and I'm sorry about confusion. -- theslaz ------------------------------------------------------------------------ theslaz's Profile: http://www.thecodecage.com/forumz/member.php?userid=44 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35320
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
