Register
Log In
Unanswered
Home
New Member
Xtreme Pivot Tables
Power Query
Power Pivot
Power BI
May 20, 2016
Offline
Please advise how to search the data validation list (start entering data in the drop down box) or increase the size of the drop down box? Thank-you
Dashboards
June 25, 2016
Offline
Hi Melanie
I assume you want to enter a name expect Data Validation list to show all names that contains the text AL (for example) such as ALEX,ALLEN,CALLIE etc. It is not possible. I have attached an example how it can be done using a userform.
You cannot increase the size (number of lines displayed) of the DV dropdown box. Maximum is 8 lines.
Hope this helps.
Sunny
February 5, 2016
Offline
hi Melanie
Shortcut for creating dropdown box is Alt DL and any cell in excel can the length of any cell in excel can be automated by Alt HOI
Perhaps ,if you have the file send it and we can analyze the problem.
Â
Regards
Tererai
Most Users Ever Online: 57
Currently Online: clark shao
17 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Md. Rahman
Lilian Vo
Jane Kumwenda
David Miller
Efe Onwochei
LynAnn Williams
Brandy Kriger
purna chandar
E K
velissa barr
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
