Custom Drop Down Lists
Hoepfully this will be Uber qwick. I have created myself a drop down list of possible options to enter into a cell. There are in total 24 options; default has see it so you can see only the first 8 and then scroll down for to se the others. Can you change this value of 8? Also If you can change that can you change the size of text that appears in the drop down list? And if you can do that, can you use logo pictures instead of text? Super., Thanks. -- samprince ------------------------------------------------------------------------ samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168 View this thread: http://www.excelforum.com/showthread...hreadid=563652 |
Custom Drop Down Lists
right click, setup controls, change to more than 8 lines
hth regards from Brazil Marcelo "samprince" escreveu: Hoepfully this will be Uber qwick. I have created myself a drop down list of possible options to enter into a cell. There are in total 24 options; default has see it so you can see only the first 8 and then scroll down for to se the others. Can you change this value of 8? Also If you can change that can you change the size of text that appears in the drop down list? And if you can do that, can you use logo pictures instead of text? Super., Thanks. -- samprince ------------------------------------------------------------------------ samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168 View this thread: http://www.excelforum.com/showthread...hreadid=563652 |
Custom Drop Down Lists
If you created the drop-down list using DataValidationList, the 8 lines and
the text size is default and cannot be changed. Workarounds provided by Debra Dalgleish at http://www.contextures.on.ca/xlDataVal08.html#Font Gord Dibben MS Excel MVP On Fri, 21 Jul 2006 07:29:00 -0400, samprince wrote: Hoepfully this will be Uber qwick. I have created myself a drop down list of possible options to enter into a cell. There are in total 24 options; default has see it so you can see only the first 8 and then scroll down for to se the others. Can you change this value of 8? Also If you can change that can you change the size of text that appears in the drop down list? And if you can do that, can you use logo pictures instead of text? Super., Thanks. |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com