| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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
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
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
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
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number of entries in drop down box
Dave,
My question is in relation to this older posting about expanding dropdown lists to include all choices, not just 8-12. I'm currently using your 'myNavigator' code to create a floating toolbar that opens each time I start Excel. The toolbar has a dropdown in it with the names of all worksheets in the open workbook. How do I expand the dropdown list so that all 60-70 worksheet names appear WITHOUT needing to scroll? Thanks. Tondos "Dave Peterson" wrote: 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 |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number of entries in drop down box
I'm not sure you can.
If you add a combobox to a userform, it has a .listrows property that you can specify that number of rows to show. I don't see that property in the combobox placed on a commandbar. But maybe someone will see a way to do this... Tondos wrote: Dave, My question is in relation to this older posting about expanding dropdown lists to include all choices, not just 8-12. I'm currently using your 'myNavigator' code to create a floating toolbar that opens each time I start Excel. The toolbar has a dropdown in it with the names of all worksheets in the open workbook. How do I expand the dropdown list so that all 60-70 worksheet names appear WITHOUT needing to scroll? Thanks. Tondos "Dave Peterson" wrote: 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 -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number of entries in drop down box
An alternative to Dave's sheet navigator is code from Bob Phillips.
See this google search thread for the BrowseSheets macro from Bob Phillips. http://tinyurl.com/yoa3dw You should easily be able to fit 60-70 sheets onto the Form. Gord Dibben MS Excel MVP On Sat, 14 Feb 2009 12:37:02 -0800, Tondos wrote: Dave, My question is in relation to this older posting about expanding dropdown lists to include all choices, not just 8-12. I'm currently using your 'myNavigator' code to create a floating toolbar that opens each time I start Excel. The toolbar has a dropdown in it with the names of all worksheets in the open workbook. How do I expand the dropdown list so that all 60-70 worksheet names appear WITHOUT needing to scroll? Thanks. Tondos "Dave Peterson" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I lock a drop down cell so only drop down entries can be e. | Excel Discussion (Misc queries) | |||
| hyperlinked drop-down entries | Excel Discussion (Misc queries) | |||
| Increasing number of unique entries in the drop-down list | Excel Discussion (Misc queries) | |||
| Creating a certain number of entries based on a number in a cell | Excel Worksheet Functions | |||
| Drop 3 Lowest Entries | Excel Worksheet Functions | |||
Hybrid Mode
