ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   ComboBox (https://www.excelbanter.com/excel-worksheet-functions/232930-combobox.html)

Chris

ComboBox
 
I am using a ComboBox for a drop list. How can I increase rows in the box
because i can only get it to show 121 rows?
--
Chris

Shane Devenshire[_2_]

ComboBox
 
Hi,

What type of combobox are you using - Form control, Toolbox control, or Data
Validation? When you say you can only see 121, does this mean you can't
scroll below the 121st item?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Chris" wrote:

I am using a ComboBox for a drop list. How can I increase rows in the box
because i can only get it to show 121 rows?
--
Chris


Chris

ComboBox
 
I am using a toolbox control and data validation together and it will only
scroll down 121 rows and not show all my list
Chris


"Shane Devenshire" wrote:

Hi,

What type of combobox are you using - Form control, Toolbox control, or Data
Validation? When you say you can only see 121, does this mean you can't
scroll below the 121st item?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Chris" wrote:

I am using a ComboBox for a drop list. How can I increase rows in the box
because i can only get it to show 121 rows?
--
Chris


Chris

ComboBox
 
I'm using Toolbox control I believe and what is happening is it is not
including my whole list of items for validation. My list goes from R1 - R126
and the box will only scroll to R121.
--
Chris


"Shane Devenshire" wrote:

Hi,

What type of combobox are you using - Form control, Toolbox control, or Data
Validation? When you say you can only see 121, does this mean you can't
scroll below the 121st item?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Chris" wrote:

I am using a ComboBox for a drop list. How can I increase rows in the box
because i can only get it to show 121 rows?
--
Chris



All times are GMT +1. The time now is 02:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com