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

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

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

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


.

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