Hi Experts,
I have a template with few fields can be selected from the drop down (list). But selecting a value from drop down which has 400 entries is difficult for the users. Is there a way to have searchable drop down? Similar to “Filter” Ex: If I type Service, it shows only the entries with the word Service.
Thanks,
Senthil
Use a forms control combobox
Ben Van Johnson
Hi, Thanks for your reply. I need to select the value from the drop down and copy/fill series by dragging to multiple rows. Please refer the example and advise how your suggestion suits that.
You need VBA for this - as was suggested in the sample file. A regular DD is not searchable
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Re: Searchable drop down list
maybe adapt this one (on THIRD sheet) or any other
type (letter or part of the name) in DV then select appropriate name
Hi sandy,
Thanks for your response. I tried you sheet to search for names like “clint” or “luc” or “paula” and I don’t get any results. But these strings are part of the name in sheet 2. Not sure whether I am doing right or spoiled your file.
Thanks,
Senthil
on THIRD sheet: If you type "clint" then click on the arrow you should see Clinton Barron, if you type letter "a" you should see all the names contain "a" letter. Every time you need click drop down arrow
Of course these strings are part of the source. What you want to find without source?
Edit:
maybe here you'll find something for your needs: DataValidation
Last edited by sandy666; 02-12-2018 at 03:23 AM. Reason: see edit
When I click the arrow, nothing happens.
Re: Searchable drop down list
I don't know what you are doing there but it should be like this:
dvclint.jpg or mdv.jpg
Have macros been enabled?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
macro enabled is not necessary
on xlsx
bdv.jpg
Last edited by sandy666; 02-12-2018 at 03:38 AM.
I enabled still
macros.PNG
fyi, even the normal drop down of list not working.
maybe show all detailed steps what you are doing there:
open file
then click....
then ....
Attach the file that is not working for you. We can then work out what you have done to break it.
Please find the attachment. I tried with xlsx and xlsx
SLIST refers to this: =OFFSET(FIRST!$B$3,,,COUNTIF(FIRST!$B$3:$B$102,"?*"))
You have removed the data from that range. Same issue with the other named range.
you can delete FIRST sheet
you can delete SLIST from Name Manager
turn ON: Options - Formulas - Enable Interative Calculation
and try again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks