Absolutely perfect! Needed this exact thing as i have users that have multiple different versions of excel... some old and don't except the filter function!! saved my day! Thankyou!!
Excellent video Sumit! It saved my countless hours, agony and possibly a computer as might have thrown it out of the window if I was to figure this out all by myself!
This was incredibly useful... thank you SO much for sharing.. I love the way you present and am now a HUGE fan! So glad I found your channel. All the best from Switzerland!
Superb sir. I followed ur clear instructions and created my first drop down list suggestions, but if i need to learn how to repeat these lists in a row. i will be very thankful to u if u could guide me for that
Your video is AMAZING!!! I understood everything you instructed! I want to tell my coworkers, but then they will no longer need my skill : ) Thank you for simplifying my job! Best wishes...from a new subscriber!
Awesome! Great solution! I wish this technique could be used in Data validation lists which are sometimes more useful than form or activex controls because they can be inserted in many cells at once. Many customers ask me about it...
Thanks For Sharing Such kind of info. You Work is Helpful to me. I Need an example like, if i start typing in a specific column cell and want to search from specific Suggestion Drop Down List(Not a Combo Box) in Excel VBA, it's very helpful me/others if you create a video on this. Thanks For This Video..... :)
am working with CELL("address") function within INDIRECT to allow multiple cells as a searchable drop downlinst, and all is working fine, Problem is, CELL("address") function use whole Workbook cells, (where ever I type no matter which Sheet I am working. I want to use specific sheet cell addresses, so when ever I work on other sheets this list should not update every time. Plz help
Please help me, am I wrong or there is a bug... When I type in 18:21 I dont know way how to edit formula directly in the document, excel always put me in formula bar and I cant get the same result as you. Do you have any advice? Thank you for many useful tutorials.
Big Thanks Dear , it is very helpful , i do same your setup , it is working fine . i will create such of this in my office . If you have more ways like this , will be happy to see >>>>>> sorry about my poor English
Great video which works really well! My only draw back is that my lists have duplicate entries which all of them get displayed in the results! Not just one! Any ideas as this would just put the cherry on the cake!
Great tutorial! Thank you. I got a minor concern, it seems like an excel bug wherein the excel program will crash if you press arrow buttons while the search results show. Has anyone experienced this?
Hi - thank you for this!!! But i would like to duplicate that Drop down list to use this for student scheduling. So i would need that drop down several hundred times. Is there a fast way to duplicate the drop down, while also keeping it aligned with other student information in 3 columns to the left of each drop down.
Hi Sumit, Thanks for the detailed tutorial. This search is working well with one particular cell. I was wondering how to implement this search for all cells in a column. Please provide the appropriate links...appreciate it!
Hello, thank you for this excellent tutorial. I have a question though. How to make this dropdown list with input like google dynamic. Ie that when I add a line in my database, it is available in my drop-down list? Thank you in advance for your great videos and your future response.
Hello - thanks for the guided steps along with explanations. My question is - all these steps has created one singular Drop-Down box. Would it be possible to create many duplicates of this box within the same sheet? I have several rows of data, and for each row, I need a searchable drop-down list (and all these duplicated searchable boxes would be pulled from one master list). Would you please guide how this can be done, if possible in the first place? Additionally, how do I add conditional formatting (cell fill colour) to such a searchable list? Thank you.
I find this tutorial very helpful. I do have a question though, how to put a feature wherein i can choose the suggested word on the dropdown by using the arrow down button?
Excellent tutorial! I really like your attention to explaining how each portion of thre formulas work. i have one question, how can you add this same code to a combo box control that is in a excel VBA Form? I dont see the properties you indicated in your website for that typy of control. I would like to add it to my form instead of my worksheet. Appreciate the lesson.
Hi. Thanks for the video. Just a question: The combo box activates everytime data is entered in another cell and hit enter, tab, delete, space and backspace keys on the keyboard. Would you have a solution for it? Thank you
Hi Kevin, what if someone will not select from drop down option and mention incorrect name, meaning instead of selecting from drop down option for United, person mention Utinated text and save the file. How we can restrict a person to select the name from the list or incorrect name is not allowed?
Hi i am new to creating custom excel sheets and this worked really well so thankyou for your easy to understand video.one thing I trying to do I also place a Vlookup function within the linked cell,this works fine for the first selection how however once one"country" has been inputted it deletes the vlookup function,is there any way to keep the vlookup function in the background of the cell without deleting it???? Many Thanks
Hello Sir, I am one of your subscribers. I am working on a project at my office. I need to know "How to create sorted dynamic searchable or predictable drop-down list in Excel like Google?" instantly. You did it well on this video, but those are not sorted. I want my drop-down list to be sorted as well as searchable or predictable like Google. I need it immediately. So, please make a video on this topic as soon as possible.
Your tutorial video was one of the best for me as a basic excel learner. I used it with our 3000+ item pharmacy where barcode does not fit. Upon using, I noticed about auto selection of combobox instead of mouse selection. Can anybody tell me how to add this in one macro. Just like Range(Cell number/Array).Selection in normal cell and array. What about in ComboBox?
Hello, how can you use the searchable drop box in multible sheets using the same name range? Please help. Thank you for your video, it's really excellent.
Thanks for the great tips. I'm looking to take this tutorial one step further. This creates ONE drop-down list, I want to create multiple lists from the same data set. Copy and Paste does not work, for obvious reasons, it's it's not feasible to regenerate the list/formulas for each drop-down menu. further help would be great!
Sir undoubtedly this was a great video, but i have two questions firstly, in ur example u used a fixed set of data, what if data keeps on increasing, secondly how to use such combobox with userform... Plz ans it would be a big help for my office project
Hi, I would need a little bit of help, I'm having a little bug after programming it. Everytime i enter another cell and then leave it (no matter which), the chosen name of my dropdownlist reappears as an option to select, and it will even appear in other pages. I need help to fix this please!
Hi Sumit, I have listened to your great tutorial many times and followed all the directions. Everything works well except for the search suggestion. I don't get a drop down list. When I return to the properties of the combo box I notice that I am unable to save "DropDownList" in the ListFillRange. Can you help? Thank you!
Thank you very much. I' ve been looking for this over a year now. The only problem i have is when i want to have 2 or more combo boxes. I' ve tried it but i have a problem. While i' ve found a result in the first box and try to wright in the second it drops down the first box. Any suggestions pls.
Super thankful for the tutorial. My excel keeps crashing though after adding it :/ Any advice on how to solve it? I also added different dropdowns to different tabs (mapped to different lists ) and sometimes when I change to a different tab, I still see the dropdowns from other tabs, as if they were pending a selection. The lists are not interconnected between tabs though. Is anyone experiencing similar issues? Thank you all!
Gm Its exactly i was looking for. Perfect... Sir instead of searching for the input of combobox at any place Like if I press i combo populates india , indonesia only.
sir i have an database for travel or transport destination list so how can create an dropdown list of two combobox like from in one to or going place in other then go
I made this dropdown list on my workbook and while it works very well, the drop down list has an issue in my workbook. I am now getting a runtime error 2147417848(80010108) method listfillrange of object IMdcCombo failed. Also, the dropdown list stays on the screen even when we switch to another page and it is there even when we have another workbook open, any thoughts on how to fix?
Thank you very much for this tutorial, it was very very good and helpful. Saved me alot of time and trouble. The only thing that bothers is that the dropdownlist pops open automatically after every calculation (or F9). Could you please advise me about this.
Ahmed Ulusoy I finally found it: in the website the code is:Private Sub ComboBox1_Change()ComboBox1.ListFillRange = "DropDownList" Me.ComboBox1.DropDown End Sub It should be:Private Sub ComboBox1_GotFocus()ComboBox1.ListFillRange = "DropDownList" Me.ComboBox1.DropDown
If i change calculation method (or F9) the dropdownlist of the combobox re-appears and i have to click it away manually with the mouse. Neither do i have a shortcut keyboard key to close a dropdownlist. I run a macro and cant close the dropdown list automatically. How can i do this???Please help!
Ahmed Ulusoy I finally found it: in the website the code is:Private Sub ComboBox1_Change()ComboBox1.ListFillRange = "DropDownList" Me.ComboBox1.DropDown End Sub It should be:Private Sub ComboBox1_GotFocus()ComboBox1.ListFillRange = "DropDownList" Me.ComboBox1.DropDown End SubRegards...
Thank you for the vedio. It really helped. I have successfully implemented it into my worksheet. But as I use the down arrow key in the keyboard to select from the drop down list, excel stops working. Does anyone else is encountering the same problem. Does it have a solution or the value from the list can only be selected by cursor.
I'm having the same problem & have not found a solution yet. Excel crashes and usually recovers. I would like the list on a separate (hidden page) from the DD list/combo box. Unable to get it working correctly when I cut/paste the DD on a diff tab.
I have used this successfully as part of an automation which navigates to webpages based on user selection of suggested keywords. The script works great but I am facing an aesthetic challenge. Once the user selects the option and say opens another excel, the combo box search area kinda pops up in the new excel as well. I am assuming its cause of the change function. I have tried writing code in the change function to execute it only if the specific sheet is a active but it doesn't seem to work.Any solution to this issue please? also the environment is citrix which I feel might be the culprit here..
somehow when i type a name in the command box, i do not get the flashing cursor, nor do I get to see the drop down menu as a I type. I redid it already 3 times?
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
Love the discovery of the double negative shortcut in front of the functions and what it does, thanks for showing this!
You are a good tutor / teacher sir. Clarity is your forte. regards
Absolutely perfect! Needed this exact thing as i have users that have multiple different versions of excel... some old and don't except the filter function!! saved my day! Thankyou!!
Excellent video Sumit! It saved my countless hours, agony and possibly a computer as might have thrown it out of the window if I was to figure this out all by myself!
Thanks for the tutorial! As an excel beginner, I find the video makes complex coding processes easy to execute !
This video is awesome. I understood everything as you instructed here. Thanks a lot.
Excellent..!!!....explained very easily....Thanx alot
Excellent Video! Thanks for your help!
This was incredibly useful... thank you SO much for sharing.. I love the way you present and am now a HUGE fan! So glad I found your channel. All the best from Switzerland!
Excellent tutorial. Thank you for sharing this very useful method.
Superb sir. I followed ur clear instructions and created my first drop down list suggestions, but if i need to learn how to repeat these lists in a row.
i will be very thankful to u if u could guide me for that
you are a blessing, this really helps. thank you so much
Very helpful, informative and well presented. Thank you
Wonderfully explained
would you be able to use the arrow down key to select from the dropdown list?
Excellent innovation..this really feels handy to use it in the sheets with large data sets..Thank u so much..keep shining..🎇🎇👏👏🤝🤝
Hi Sumit.. love this technique. Putting it to use right away. Thanks for sharing. Thumbs up!!
Your video is AMAZING!!! I understood everything you instructed! I want to tell my coworkers, but then they will no longer need my skill : ) Thank you for simplifying my job! Best wishes...from a new subscriber!
That was really great! To make it perfect we should have it directly inside the cell like it is for example in Delphi RAD when you code.
Thank you for the very informative video! I will have to apply your technique at my work.
Awesome! Great solution! I wish this technique could be used in Data validation lists which are sometimes more useful than form or activex controls because they can be inserted in many cells at once. Many customers ask me about it...
Very informative videos🤩😍
Great Explanation!!! Can you please confirm if the same can be done on each cell of a table so that it is easily for data entry.
Thanks
Thanks For Sharing Such kind of info. You Work is Helpful to me. I Need an example like, if i start typing in a specific column cell and want to search from specific Suggestion Drop Down List(Not a Combo Box) in Excel VBA, it's very helpful me/others if you create a video on this. Thanks For This Video..... :)
hi sir , thanku very much for the video,
how can i auto populate contact number of the person as their name appears on the drop box.
This is what i've been looking for a long time ago. :O, Thank you very much for sharing!!!
Excellent work!
This is wonderful! Thank you a ton!
Thanks this is very helpful !
Hi Sumit - your tutorial is great. Is there a ways to have multiple comboboxes on the same sheet?
Hhh
works but from the drop down list if i use the keyboard down arrow to select a text the worksheet crashes. any fix for this?
Fantastic solution! It helped me a lot in my work :)
am working with CELL("address") function within INDIRECT to allow multiple cells as a searchable drop downlinst, and all is working fine, Problem is, CELL("address") function use whole Workbook cells, (where ever I type no matter which Sheet I am working. I want to use specific sheet cell addresses, so when ever I work on other sheets this list should not update every time. Plz help
Can we dock the combobox into the cell so it will autofit when we shrink or enlarge the cell ?
Superb ! Great vid Thanks a lot
Please help me, am I wrong or there is a bug... When I type in 18:21 I dont know way how to edit formula directly in the document, excel always put me in formula bar and I cant get the same result as you. Do you have any advice? Thank you for many useful tutorials.
Big Thanks Dear , it is very helpful , i do same your setup , it is working fine . i will create such of this in my office . If you have more ways like this , will be happy to see >>>>>> sorry about my poor English
Dear Sumit Bansal, Thanks a lot....... Superb.......
Good stuff there! Great explanation.
Great video which works really well!
My only draw back is that my lists have duplicate entries which all of them get displayed in the results! Not just one! Any ideas as this would just put the cherry on the cake!
This is good tutorial. How do I use search when data is present in different worksheet.
Great tutorial! Thank you. I got a minor concern, it seems like an excel bug wherein the excel program will crash if you press arrow buttons while the search results show.
Has anyone experienced this?
Hi - thank you for this!!! But i would like to duplicate that Drop down list to use this for student scheduling. So i would need that drop down several hundred times. Is there a fast way to duplicate the drop down, while also keeping it aligned with other student information in 3 columns to the left of each drop down.
Brilliant Sumit....keep it up!!!
This works only for combo box.i need to create searchable drop down list for complete worksheet.Please suggest.
This is fantastic - excellent video!
May I ask how I can easily add multiple dropdowns with the same selections to a workbook?
did you find an answer?
The example only has the one combo box that links to B3. Could this work for cells from say B:B?
Is there a VBA way to do this ?
Thanks
Please sugeest best channel on youtube for vba excel
Thanks that helped me a lot 👍
Hi Sumit, Thanks for the detailed tutorial. This search is working well with one particular cell. I was wondering how to implement this search for all cells in a column. Please provide the appropriate links...appreciate it!
Thank you bro ☺️❤️
You are awesome man.
Awesome!
Sir I am very big fan of you
Sir, i see your Videos. that are also Awesome !
Hello,
thank you for this excellent tutorial. I have a question though. How to make this dropdown list with input like google dynamic. Ie that when I add a line in my database, it is available in my drop-down list?
Thank you in advance for your great videos and your future response.
can you apply this into a cell? instead of on combo box?
Hello - thanks for the guided steps along with explanations.
My question is - all these steps has created one singular Drop-Down box. Would it be possible to create many duplicates of this box within the same sheet?
I have several rows of data, and for each row, I need a searchable drop-down list (and all these duplicated searchable boxes would be pulled from one master list).
Would you please guide how this can be done, if possible in the first place?
Additionally, how do I add conditional formatting (cell fill colour) to such a searchable list?
Thank you.
***** Thanks for your reply.
I find this tutorial very helpful. I do have a question though, how to put a feature wherein i can choose the suggested word on the dropdown by using the arrow down button?
Hi, How would you apply this to more than one cell? Would you have to create a ComboBox for each cell?
Excellent tutorial! I really like your attention to explaining how each portion of thre formulas work. i have one question, how can you add this same code to a combo box control that is in a excel VBA Form? I dont see the properties you indicated in your website for that typy of control. I would like to add it to my form instead of my worksheet. Appreciate the lesson.
Hi. Thanks for the video. Just a question: The combo box activates everytime data is entered in another cell and hit enter, tab, delete, space and backspace keys on the keyboard. Would you have a solution for it? Thank you
Hi Sam, i have the same problem, did you find a solution? thank you
Hi Kevin, what if someone will not select from drop down option and mention incorrect name, meaning instead of selecting from drop down option for United, person mention Utinated text and save the file. How we can restrict a person to select the name from the list or incorrect name is not allowed?
Hi i am new to creating custom excel sheets and this worked really well so thankyou for your easy to understand video.one thing I trying to do I also place a Vlookup function within the linked cell,this works fine for the first selection how however once one"country" has been inputted it deletes the vlookup function,is there any way to keep the vlookup function in the background of the cell without deleting it????
Many Thanks
Do you know how to use mouse scroll wheel go down on drop down list you created?
Thanks a lot for the video. Works well on a worksheet but I can't seem to get it to work when the search is on a userform. Any advice?
This bothers me as well buddy..
Can I create same for multiple rows?
Very useful!
Thanks for sharing.
Can we also do this with alphanumeric or numeric search?
Hello Sir, I am one of your subscribers. I am working on a project at my office. I need to know "How to create sorted dynamic searchable or predictable drop-down list in Excel like Google?" instantly. You did it well on this video, but those are not sorted. I want my drop-down list to be sorted as well as searchable or predictable like Google. I need it immediately. So, please make a video on this topic as soon as possible.
Your tutorial video was one of the best for me as a basic excel learner.
I used it with our 3000+ item pharmacy where barcode does not fit.
Upon using, I noticed about auto selection of combobox instead of mouse selection.
Can anybody tell me how to add this in one macro.
Just like Range(Cell number/Array).Selection in normal cell and array.
What about in ComboBox?
Hey I need help in my 2016 version,
I used the formula but it always return to 1 even if there is none been inputed into the cell
Hello, how can you use the searchable drop box in multible sheets using the same name range? Please help.
Thank you for your video, it's really excellent.
Can we do this in Userform combobox ?
Thanks for the great tips. I'm looking to take this tutorial one step further. This creates ONE drop-down list, I want to create multiple lists from the same data set. Copy and Paste does not work, for obvious reasons, it's it's not feasible to regenerate the list/formulas for each drop-down menu. further help would be great!
Excelent, good tech, fantastic!!
Hello sir Trump Excel, can you have a tutorial, using data validation with dropdown list with search suggestion? Thanks..You did a very good tutorial.
Sir undoubtedly this was a great video, but i have two questions firstly, in ur example u used a fixed set of data, what if data keeps on increasing, secondly how to use such combobox with userform... Plz ans it would be a big help for my office project
great solution , i like it.
Hi, I would need a little bit of help, I'm having a little bug after programming it. Everytime i enter another cell and then leave it (no matter which), the chosen name of my dropdownlist reappears as an option to select, and it will even appear in other pages. I need help to fix this please!
Thanks a ton!
Thank you very much man!! Great great tutorial :)
Hi Sumit, I have listened to your great tutorial many times and followed all the directions. Everything works well except for the search suggestion. I don't get a drop down list. When I return to the properties of the combo box I notice that I am unable to save "DropDownList" in the ListFillRange. Can you help? Thank you!
Hi Sumit, this was a fantastic video and very well explained. ThumbsUp!!
Can we do the same sort of search with a combobox in userform?
Thank you very much. I' ve been looking for this over a year now. The only problem i have is when i want to have 2 or more combo boxes. I' ve tried it but i have a problem. While i' ve found a result in the first box and try to wright in the second it drops down the first box. Any suggestions pls.
How to give cell reference F3:F3 via shortcut key? 7:00
Super thankful for the tutorial. My excel keeps crashing though after adding it :/ Any advice on how to solve it? I also added different dropdowns to different tabs (mapped to different lists ) and sometimes when I change to a different tab, I still see the dropdowns from other tabs, as if they were pending a selection. The lists are not interconnected between tabs though. Is anyone experiencing similar issues? Thank you all!
It's happening to me just the same and I still don't know how to solve it 😕
Gm
Its exactly i was looking for. Perfect... Sir instead of searching for the input of combobox at any place
Like if I press i combo populates india , indonesia only.
Is it possible to link the combobox to more than one cell?
sir i have an database for travel or transport destination list so how can create an dropdown list of two combobox like from in one to or going place in other then go
is there any way not to use VBA code ?
thank you !
I made this dropdown list on my workbook and while it works very well, the drop down list has an issue in my workbook. I am now getting a runtime error 2147417848(80010108) method listfillrange of object IMdcCombo failed. Also, the dropdown list stays on the screen even when we switch to another page and it is there even when we have another workbook open, any thoughts on how to fix?
thank you i did you are good teacher
awesome! thx so much for sharing
Thank you very much for this tutorial, it was very very good and helpful. Saved me alot of time and trouble.
The only thing that bothers is that the dropdownlist pops open automatically after every calculation (or F9). Could you please advise me about this.
Ahmed Ulusoy I finally found it: in the website the code is:Private Sub ComboBox1_Change()ComboBox1.ListFillRange = "DropDownList"
Me.ComboBox1.DropDown
End Sub
It should be:Private Sub ComboBox1_GotFocus()ComboBox1.ListFillRange = "DropDownList"
Me.ComboBox1.DropDown
Hi, have you found a solution with this, i need help to fix the same problem you're describing, thank you
hi sumit, thats amazing, the excel sheet is going closed after running the vba. any solution!
Is it possible to make the same Dynamic Search in a Excel 2010, Userform, Combobox ?
If i change calculation method (or F9) the dropdownlist of the combobox re-appears and i have to click it away manually with the mouse. Neither do i have a shortcut keyboard key to close a dropdownlist.
I run a macro and cant close the dropdown list automatically. How can i do this???Please help!
Ahmed Ulusoy I finally found it: in the website the code is:Private Sub ComboBox1_Change()ComboBox1.ListFillRange = "DropDownList"
Me.ComboBox1.DropDown
End Sub
It should be:Private Sub ComboBox1_GotFocus()ComboBox1.ListFillRange = "DropDownList"
Me.ComboBox1.DropDown
End SubRegards...
Thank you for the vedio. It really helped.
I have successfully implemented it into my worksheet. But as I use the down arrow key in the keyboard to select from the drop down list, excel stops working. Does anyone else is encountering the same problem. Does it have a solution or the value from the list can only be selected by cursor.
I'm having the same problem & have not found a solution yet. Excel crashes and usually recovers.
I would like the list on a separate (hidden page) from the DD list/combo box. Unable to get it working correctly when I cut/paste the DD on a diff tab.
+Trump Excel, I have a Mac with Numbers. How do you do this with that? it doesn't have a Combo box.
I have used this successfully as part of an automation which navigates to webpages based on user selection of suggested keywords. The script works great but I am facing an aesthetic challenge. Once the user selects the option and say opens another excel, the combo box search area kinda pops up in the new excel as well. I am assuming its cause of the change function. I have tried writing code in the change function to execute it only if the specific sheet is a active but it doesn't seem to work.Any solution to this issue please? also the environment is citrix which I feel might be the culprit here..
somehow when i type a name in the command box, i do not get the flashing cursor, nor do I get to see the drop down menu as a I type. I redid it already 3 times?
Very useful thanks