View all entries in Validation List

[Guest]

Is there a way I can extend the view of my drop down list (validation list)
so that a scroll bar does not appear? I have a list of 12 items, but only 7
can be viewed; the viewer has to scroll down to see the remaining five items
in the list. Is there a way to force Excel to display all 12 items without a
scroll bar? I can do it by using the drop down from the control toolbox
(vba), but I'm using a simple validation list (Data-->Validation).
Thanks,
Exceller

 

[T. Valko]

You can use a Combo Box from the Forms Toolbar.

Biff

 

[Guest]

Hi,
Do the following:
1. Enter a list of number under a column – for example 20 rows.
2. On the View menu, point to Toolbars, and then click Forms.
The Forms toolbar displays.
3. In the Forms Toolbar, click the Combo Box button.
The cursor now displays a “+†symbol.
4. On the worksheet, click and drag to specify the Height and Width of the
Combo
Box.
5. Right-click the Combo Box and click Format Control.
The Format Control dialog appears.

Note: You will see seven points on the Combo Box. If you want to change the
Height or Width of the Combo Box, click on any of the selection point to
modify the shape.

6. Click the Control Tab.
7. In the Input Range text box, enter the cell range or click the image next
to the
Input Range text box to manually select the cell range.
8. In the Drop down lines, specify the total number of cells you want to
display,
when click the filter list arrow.

Note: You can have different ranges and drop down line for different Combo
Boxes you place in the Work Sheet.

9. Click OK. To return to the worksheet. Then click any where in the
worksheet to
clear the Combo Box selection.

Challa Prabhu

 

[Guest]

Thanks Challa. Works like a charm.
Regards,
Exceller

 

[Guest]

Thanks T!
Exceller

You can use a Combo Box from the Forms Toolbar.

Biff