This is great and well explained, however I want to use this search facility in a textbox of a userform, can you show me what changed would be made to facilitate this please.
thanks it worked despite me thinking the referencing might be quite messed up. Can you please explain what the doe is actually doing. and what are those syntaxs or libraries or whatever they are called are working, with examples for each function.
Thanks for the video, it's helped me quite a bit. I have a few questions too. 1) Is there a way to scroll through the list using the up/down arrow keys without having the Text change in the input field? 2) Is there a shorter line of code to replace the one for the .List? Having to type Worksheets("Data")... is a bit much and I feel like there should be a better way to do it. Maybe with Named Ranges. 3) Is it possible to do a Step Counter of +1 instead of -1? (I get an error when I try to) 4) I don't think this can be fixed, but the .ListRows doesn't update In-Real-Time as one is typing. The unused rows are visible still, but they are greyed out. Thanks again!
Thanks for the video, its help me a lot. Could you explain how to make combobox empty after entry data? Cause I tried this "combobox="" " But combobox always show the list. Thank you
@@ExcelDestination 👍 Good things here, learning alot. Help me also do this: I have created a vba userform with autocomplete drop-down combobox search creteria but when I search based on a number or date column it is not able to search. It only searches text-data type columns. How can I modify the code to search for numbers, date and text or combination of any of the data types. Your response will be highly appreciated. Thanks in advance
Excellent video and very helpful too. I have couple of queries with this code. Hope you will help me out with that. 1. While we erase out all typed letter in combobox, dropdown list should not be visible. 2. if have two similar names in combobox dropdown list, then keydown does not work. Can you please suggest the solution of the above two queries?
Need help It's fantastic but when I type numbers with "/ " like 12/2 it automatically changed into date format like 12/20/2023 and not work backspace to remove year value . Please help 🙏
How can I see all listed items when pressing down_arrow at the first start of using ComboBox? It shows nothing now. You should type some words before Box stars showing all the items...
Sir, I have a worksheet. In sheet1, column 'AN' I have a list which is a name range. And I want a drop down list in Sheet3, B5 cell. How can I customize your code? Please help me.
hello, thanks how would be the code if i want this in a combobox inside o userform, i have spent some time trying to adapt yours but i get multiple errors and i do not know how to continue, help much appreciated
Hello Thanks for the video I have 3 lakhs plus item names in excel and want to fetch its correct and unique names from google Can you please suggest me how can I get unique names from google?
Hello, thanks for this great Video! If i click on an Element inside the dropdown, the dropdown collapses and the Combobo don´t show the selected Item. If i Tab out & back in, the selection also disappears. Can you please have a look at my Code? ------------ Private Sub BaseSelect_Enter() ArtikelKat = "BASE" If Len(BaseFilter.Text) Then With BaseSelect .Clear .List = ComboFiltered(ArtikelKat, BaseFilter.Text) .DropDown End With Else With BaseSelect .Clear .List = ComboUnfiltered(ArtikelKat) .DropDown End With End If End Sub ----------- Private Sub BaseSelect_Change() ArtikelKat = "BASE" If Not Comb_Arrow Then With Me.BaseSelect .Clear .List = ComboUnfiltered(ArtikelKat) .DropDown If Len(.Text) Then .Clear .List = ComboFiltered(ArtikelKat, BaseSelect.Text) 'Function to return array with all multi inStr matches from .text entry .DropDown End If End With End If End Sub ------------ Private Sub BaseSelect_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) Comb_Arrow = (KeyCode = vbKeyUp) Or (KeyCode = vbKeyDown) If KeyCode = vbKeyReturn Then Me.BaseSelect.List = ComboFiltered(ArtikelKat, BaseSelect.Text) End Sub -------------- Thanks in Advance! ;)
Very good tutorial appreciated. It is very good for beginners, hope to see more. Thanks
thanks a lot!!
Merci pour cette vidéo, Elle m'a aidé à résoudre plusieurs problème de ma sélection
Thanks in a million. Great content. Awesome imagination.Grade: A++💥
Our pleasure!
This is great and well explained, however I want to use this search facility in a textbox of a userform, can you show me what changed would be made to facilitate this please.
it's worked for me, Thank you so muchhhhhhh
Muchisimas gracias desde "Ecuador"
Thanks a lot sir, It is very good and it helped me a log.
Great Work, But you should add an option after selection to hit enter or tap to go to next cell
thanks it worked despite me thinking the referencing might be quite messed up. Can you please explain what the doe is actually doing. and what are those syntaxs or libraries or whatever they are called are working, with examples for each function.
Thanks a lot. Very helpful
welcome
Thanks for the video, it's helped me quite a bit. I have a few questions too.
1) Is there a way to scroll through the list using the up/down arrow keys without having the Text change in the input field?
2) Is there a shorter line of code to replace the one for the .List? Having to type Worksheets("Data")... is a bit much and I feel like there should be a better way to do it. Maybe with Named Ranges.
3) Is it possible to do a Step Counter of +1 instead of -1? (I get an error when I try to)
4) I don't think this can be fixed, but the .ListRows doesn't update In-Real-Time as one is typing. The unused rows are visible still, but they are greyed out.
Thanks again!
هةقص٦ضفيض
Thanks my pro u very good teacher
Glad to hear that
Thank Yon Bhai..
its worl fine, thanks
Vídeo excelente!
Thanks
Thanks for the video, its help me a lot.
Could you explain how to make combobox empty after entry data?
Cause I tried this "combobox="" "
But combobox always show the list.
Thank you
مرسی
thanks very muts ......
Thank you so mutch, Sir.
You are most welcome
@@ExcelDestination 👍 Good things here, learning alot. Help me also do this: I have created a vba userform with autocomplete drop-down combobox search creteria but when I search based on a number or date column it is not able to search. It only searches text-data type columns. How can I modify the code to search for numbers, date and text or combination of any of the data types. Your response will be highly appreciated. Thanks in advance
Hi, thanks for the video!
Could you tell us if you know how to extend the combo box to a whole column?
Excellent video and very helpful too. I have couple of queries with this code. Hope you will help me out with that.
1. While we erase out all typed letter in combobox, dropdown list should not be visible.
2. if have two similar names in combobox dropdown list, then keydown does not work.
Can you please suggest the solution of the above two queries?
Hi Sir,
Need help, why i get error permission denied ?
thanks for this man.
welcome
thanks brow
Thanks
hi sir i found error this line plz help If InStr(1, .List(i), .Text, vbTextCompare) = 0 Then
How can I make the actual cells do what the combo box does?
Can we filter data automatically using combobox in same destination like textbox.
When changing to from Change() to Click() or Dropdownlist doesn't work any ideas?
Thank you, can we repeat this combo box in all the cells of the table
yes
Need help
It's fantastic but when I type numbers with "/ " like 12/2 it automatically changed into date format like 12/20/2023 and not work backspace to remove year value .
Please help 🙏
good job!
thank you
How can I see all listed items when pressing down_arrow at the first start of using ComboBox? It shows nothing now. You should type some words before Box stars showing all the items...
Sir, I have a worksheet. In sheet1, column 'AN' I have a list which is a name range. And I want a drop down list in Sheet3, B5 cell. How can I customize your code? Please help me.
same question here
How to repeat same combo box in same coloum? Say avg 5000 times.
If so please guide me to do it.
Sir how to add two columns in combobox and seach accordingly?
hello, thanks how would be the code if i want this in a combobox inside o userform, i have spent some time trying to adapt yours but i get multiple errors and i do not know how to continue, help much appreciated
EXCELENT, SIR, I AM VERY VERY THANKFULL TO YOU
You are most welcome
sir
what is the code for unique values for
VBA ComBox Box with AutoComplete Search
please Share
literrally did the same way copied created the excel .. still getting error 70 permission denied... where we are going wrong
Hello Sir… really interesting work … I did the same in everything but I have a problem… error 438 … please help… thank you in advance
Hello
Thanks for the video
I have 3 lakhs plus item names in excel and want to fetch its correct and unique names from google
Can you please suggest me how can I get unique names from google?
If we use indirect formula in drop down list then this coding is't work
not working with Userform combox..
can you pls help me with one demo excel
Hi, this was a very helpful video. Is it possible to do the same thing combining 2 lists of data on 2 separate worksheets?
Hello
Excel Destination
Please can you help me ?
I send you by e-mail my file .
Couse i truing do from your video but it not working .
wow
thank you
Not good
Hello, thanks for this great Video!
If i click on an Element inside the dropdown, the dropdown collapses and the Combobo don´t show the selected Item. If i Tab out & back in, the selection also disappears. Can you please have a look at my Code?
------------
Private Sub BaseSelect_Enter()
ArtikelKat = "BASE"
If Len(BaseFilter.Text) Then
With BaseSelect
.Clear
.List = ComboFiltered(ArtikelKat, BaseFilter.Text)
.DropDown
End With
Else
With BaseSelect
.Clear
.List = ComboUnfiltered(ArtikelKat)
.DropDown
End With
End If
End Sub
-----------
Private Sub BaseSelect_Change()
ArtikelKat = "BASE"
If Not Comb_Arrow Then
With Me.BaseSelect
.Clear
.List = ComboUnfiltered(ArtikelKat)
.DropDown
If Len(.Text) Then
.Clear
.List = ComboFiltered(ArtikelKat, BaseSelect.Text) 'Function to return array with all multi inStr matches from .text entry
.DropDown
End If
End With
End If
End Sub
------------
Private Sub BaseSelect_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
Comb_Arrow = (KeyCode = vbKeyUp) Or (KeyCode = vbKeyDown)
If KeyCode = vbKeyReturn Then Me.BaseSelect.List = ComboFiltered(ArtikelKat, BaseSelect.Text)
End Sub
--------------
Thanks in Advance! ;)