Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display more than 8 lines in an Excel dropdown box
Using Data Validation I can only get the drop-down box to display a maximum
of 8 lines, otherwise I have to use the scroll bar at the side to see the other entries. Is there any way to set it so that it displays 12 or 15 lines without having to scroll. The problem being that if the cell was blank to start with the dropdown goes to the first entry after the last non-blank. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display more than 8 lines in an Excel dropdown box
Hello Brettjg, Not possible using Data Validation. You can do it by placing a Forms Toolbar Drop Down or Controls Toolbox ComboBox (ActiveX control) on the worksheet and writting the macro code to do both the validation and extending the number drop down of lines. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=551733 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display more than 8 lines in an Excel dropdown box
you dont ned a macro to conrol a forms toolbar combo.The number of lines is a
property you can adjust in the format control menu when you right click on the combo box.To make a forms combo box functional you need to use an index or choose formula using the cell link to choose from your list -- paul remove nospam for email addy! "Leith Ross" wrote: Hello Brettjg, Not possible using Data Validation. You can do it by placing a Forms Toolbar Drop Down or Controls Toolbox ComboBox (ActiveX control) on the worksheet and writting the macro code to do both the validation and extending the number drop down of lines. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=551733 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel dropdown with text and value | Excel Worksheet Functions | |||
Open an excel file but it does not display | Excel Discussion (Misc queries) | |||
?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
Excel workbook fails to display when selecting from my documents. | Excel Worksheet Functions | |||
Add more lines and more columns in Excel | Excel Worksheet Functions |