LinkBack URL
About LinkBacks
Does someone can hlelp me to create a drop down list that works as follows:
1. It neeeds to be able to refer a diffrerent workbook for data.
2. As I am typing letteres, the possible options are to appear in the drop-down list.
Does someone can hlelp me to create a drop down list that works as follows:
1. It neeeds to be able to refer a diffrerent workbook for data.
2. As I am typing letteres, the possible options are to appear in the drop-down list.
Hello Cesar,
If the data is in another workbook and not on a different worksheet, you can not use a regular validation drop down. The Data Validation Drop Down does not support look ahead typing either. You will need to use a Control Toolbox ComboBox to do all these things.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Leith is right. here's an example.
Play with the MatchEntry Property of the ListBox / ComboBox
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks