ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lengths of LISTS (https://www.excelbanter.com/excel-discussion-misc-queries/259079-lengths-lists.html)

RLD

Lengths of LISTS
 
Is there a way to format the length and font of a drop down list?

I have a drop down list that has 100 items and would like to show more than
8 items at a time while increasing the view font within the list. Possible?

מיכאל (מיקי) אבידן

Lengths of LISTS
 
If you're talking about Data Validation - the answer is, - no.
You may try to use some form objects like ComboBox etc...
Micky


"RLD" wrote:

Is there a way to format the length and font of a drop down list?

I have a drop down list that has 100 items and would like to show more than
8 items at a time while increasing the view font within the list. Possible?


JB

Lengths of LISTS
 
With form

http://boisgontierjacques.free.fr/fi...on/DVForm2.xls

JB
http://boisgontierjacques.free.fr/

On 16 mar, 22:08, RLD wrote:
Is there a way to format the length and font of a drop down list?

I have a drop down list that has 100 items and would like to show more than
8 items at a time while increasing the view font within the list. *Possible?



JB

Lengths of LISTS
 
To reduce lenght of list, type first letter. Seesample

http://boisgontierjacques.free.fr/fi...ion/DVPays.xls

JB

On 17 mar, 08:25, JB wrote:
With form

http://boisgontierjacques.free.fr/fi...on/DVForm2.xls

JBhttp://boisgontierjacques.free.fr/

On 16 mar, 22:08, RLD wrote:



Is there a way to format the length and font of a drop down list?


I have a drop down list that has 100 items and would like to show more than
8 items at a time while increasing the view font within the list. *Possible?- Masquer le texte des messages prcdents -


- Afficher le texte des messages prcdents -




All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com