Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
View all entries in Validation List
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
View all entries in Validation List
You can use a Combo Box from the Forms Toolbar.
Biff "Exceller" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
View all entries in Validation List
Thanks T!
Exceller "T. Valko" wrote: You can use a Combo Box from the Forms Toolbar. Biff "Exceller" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
View all entries in Validation List
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 "Exceller" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
View all entries in Validation List
Thanks Challa. Works like a charm.
Regards, Exceller "challa prabhu" wrote: 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 "Exceller" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
blank entries in data validation list | Excel Worksheet Functions | |||
DataValidationList - Unique Entries | New Users to Excel | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Data Validation for Weekday entries only | Excel Worksheet Functions | |||
Using Data Validation - how do I allow other entries | New Users to Excel |