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. |
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 |
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 |
All times are GMT +1. The time now is 10:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com