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
|
|||
|
|||
Scrolling down my drop down box
I have approximately 1500 rows in my validation list for products I want to
select however when I use my drop down box I can only scroll down to about 1025 rows and the scrolling stops. How can I resolve this problem as the limitations on the number of rows in a list are almost infinite (65,000 or so from what I have read in your discussion group. Any help would be appreciated I use Office for Mac 2008 Bob |
#2
|
|||
|
|||
Scrolling down my drop down box
A drop down box has got this limitations..Instead from menu
ViewToolbarsControl Toolboxselect 'ComboBox' place this over a cell. While in design mode right click the 'combobox' control and select 'Properties' and set the below properties . Once done click the first icon in the 'Control Toolbox' to 'Exit Design mode'. Linked cel. (eg" Sheet1!C1) List Rill Range (eg: Sheet1!A1:A2500) If this post helps click Yes --------------- Jacob Skaria "MAC MAN" wrote: I have approximately 1500 rows in my validation list for products I want to select however when I use my drop down box I can only scroll down to about 1025 rows and the scrolling stops. How can I resolve this problem as the limitations on the number of rows in a list are almost infinite (65,000 or so from what I have read in your discussion group. Any help would be appreciated I use Office for Mac 2008 Bob |
#3
|
|||
|
|||
Scrolling down my drop down box
A drop down box has got this limitations..
The limit is 32,767 items (from a range). That's pretty big for a drop down list. -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... A drop down box has got this limitations..Instead from menu ViewToolbarsControl Toolboxselect 'ComboBox' place this over a cell. While in design mode right click the 'combobox' control and select 'Properties' and set the below properties . Once done click the first icon in the 'Control Toolbox' to 'Exit Design mode'. Linked cel. (eg" Sheet1!C1) List Rill Range (eg: Sheet1!A1:A2500) If this post helps click Yes --------------- Jacob Skaria "MAC MAN" wrote: I have approximately 1500 rows in my validation list for products I want to select however when I use my drop down box I can only scroll down to about 1025 rows and the scrolling stops. How can I resolve this problem as the limitations on the number of rows in a list are almost infinite (65,000 or so from what I have read in your discussion group. Any help would be appreciated I use Office for Mac 2008 Bob |
#4
|
|||
|
|||
Scrolling down my drop down box
Oops..I misread and thought scrolling down is the issue mentioned
here..Thanks Biff "T. Valko" wrote: A drop down box has got this limitations.. The limit is 32,767 items (from a range). That's pretty big for a drop down list. -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... A drop down box has got this limitations..Instead from menu ViewToolbarsControl Toolboxselect 'ComboBox' place this over a cell. While in design mode right click the 'combobox' control and select 'Properties' and set the below properties . Once done click the first icon in the 'Control Toolbox' to 'Exit Design mode'. Linked cel. (eg" Sheet1!C1) List Rill Range (eg: Sheet1!A1:A2500) If this post helps click Yes --------------- Jacob Skaria "MAC MAN" wrote: I have approximately 1500 rows in my validation list for products I want to select however when I use my drop down box I can only scroll down to about 1025 rows and the scrolling stops. How can I resolve this problem as the limitations on the number of rows in a list are almost infinite (65,000 or so from what I have read in your discussion group. Any help would be appreciated I use Office for Mac 2008 Bob . |
#5
|
|||
|
|||
Scrolling down my drop down box
Check your other post.
MAC MAN wrote: I have approximately 1500 rows in my validation list for products I want to select however when I use my drop down box I can only scroll down to about 1025 rows and the scrolling stops. How can I resolve this problem as the limitations on the number of rows in a list are almost infinite (65,000 or so from what I have read in your discussion group. Any help would be appreciated I use Office for Mac 2008 Bob -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|