| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down list
I would like, if possible, to programme Excel to show an entire drop down
list, rather than some of it and a scroll bar to find other options further down in the list. Also, can the font size (and perhaps colour) used to show the list be altered to a larger one? -- tia Jock |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drop down list
Jock,
Check out the .ListRows (maybe set = .ListCount), .Font and .ForeColour properties of the combo box. NickHK "Jock" wrote in message ... I would like, if possible, to programme Excel to show an entire drop down list, rather than some of it and a scroll bar to find other options further down in the list. Also, can the font size (and perhaps colour) used to show the list be altered to a larger one? -- tia Jock |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drop down list
Hi Jock,
It is not possible to change either the data validation font size or the list length. However. for a workaround, see Debra Dalgleish at: Data Validation Font Size and List Length http://www.contextures.com/xlDataVal08.html#Font --- Regards, Norman "Jock" wrote in message ... I would like, if possible, to programme Excel to show an entire drop down list, rather than some of it and a scroll bar to find other options further down in the list. Also, can the font size (and perhaps colour) used to show the list be altered to a larger one? -- tia Jock |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drop down list
Thanks guys
-- tia Jock "Norman Jones" wrote: Hi Jock, It is not possible to change either the data validation font size or the list length. However. for a workaround, see Debra Dalgleish at: Data Validation Font Size and List Length http://www.contextures.com/xlDataVal08.html#Font --- Regards, Norman "Jock" wrote in message ... I would like, if possible, to programme Excel to show an entire drop down list, rather than some of it and a scroll bar to find other options further down in the list. Also, can the font size (and perhaps colour) used to show the list be altered to a larger one? -- tia Jock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Linear Mode
