Hi PK. Thank you so much for this! I have searched for a solution like this before, but never found anything as good as this. I have implemented this solution on a workbook I'm building right now and it works beautifully! I love your videos.
Hi PK, I am working in Aditya Birla Group in Dubai for past 4 years in Field of Excel Automation. And i must appreciate you for the way you are explaining to the learners. I usually do not see the basic videos but your thumbnail was too attractive to refuse. Kudos to Excel. Also in case you or any of your excel enthusiastic friend want to join for some role ill be happy to help. From Mudit Lalwani
How can I change the code to show more than 7 rows in the search list ? I would like to see 10 or more rows in the search box. Keep up the good work... your tutorials are very helpful. Thank You.
Thank you so much for the video, it really helped can it be possible for an option to add data in some queue while searching from list which later can be added at once on that column . If yes, what changes should be needed the logic
It is really good tutorial keep it up But I think you can two changes in it 1. Use unload form1 instead of form1.hide 2. When form height is 164 then tabstop of radio buttons will be false also or frame may be visible = false. Otherwise tab key will effect radio buttons value.
That is amazing! Thank you for sharing this. My code is giving me an error "Next without For" in the Sub Refresh_List. I don't know how to fix it. It is looking the same as yours.
If I share the workbook for multiple user to work on it, for example sharing on DropBox will it work on other PCs if they press crtl+m ? Also, what codes to add if I press esc key in Keyboard, and the form will be closed.
Hi I am regular follower of your videos. Recently I had a universal search list box from the model you have shown. I had made some minor tweaks into it. But right now I'm facing a problem with a program. Let me first mention the tweaks which I had made. 1. I had entered a code whereby the search box will automatically popup each time I select a cell in Column A 2. When the search box appears the focus should be on the text box so that the user can immediately enter the data rather than manually clicking the text box. 3. Once the user enters data in column A the cursor selection moves to the cell right to the current cell. That is once I enter data in suppose Column A3 the cursor would move to Column B3 And now the problem: Once I type the keywords and I would select the particular item using down arrow key. The cursor as intended moves to the right. But then it sort of gets locked. I couldn't enter any data in the now active cell until I would manually double click the cell which voids the utility of using this workbook since it would consume time If I had to click the cell each and every time. Please let me know if there is a way to resolve this issue.
I'm working in Pvt automobile company, I'm doing more than 500 customer details update to vahan transport (RTO)website per month, I'm waiting for your vedio, thanks a lot Mr.
Super work, it's very useful for me. I M working in MS 2010 on big data say avg 20000 rows & 28 columns in a sheet. Is it work on MS 2010? Pls confirm me.
Bhai mein excel mein new hun, kya aap meri madad kar sakte hai, mujhe invoice mein sirf ' item description" ke row mein chahye. Quantity aur rate dalne ke baad jab niche description mein cursor aye to automatically yeh pop ho. Can you make this for me. Bahot help milegi.
Hi, I have a question, the current searchbox is enable only 1 input in that cell, but I wish to input more than 2 selection in the cell by using the searchbox, is that possible? Thank you.
16:21 sir! I'm getting an error "compyle error, block if without end if" even I have that end if on the same location also there you have in this video is there any solution for it? after doing some changes 16:22 "next without for"😭
One question, if we have a list box (data validation) it will be in a cell, then in VBA we can address that particular cell value ( D2 here). i.e. =IFERROR(MATCH(D2.Value,CustID,0)+3,"") How can this be done with Combo Box? Basically I have Cust_ID & Cust_Name and I would like to get the Cust_ID or its row when I select a customer's name from a Combo Box?
Sir can u please made vba which searchable drop-down list box open when i press a key and i search my data from it. In this video u have already drop down list in cell but my case cell is empty when i press shortcut key then search able drop down box open and i search my data from it
Sir can u please solve my problem..i want to search names data by name sound for ex ..if i have written name deepak in my data and if i forgot the spelling and i m writing dipak..then my search fails..please help
Very smart and very useful tool. You're the one of the excel contents creators that I appreciate the most. Thank you for your work PK.
You're very welcome!
SIR
SUPERB............VIDEO
I HAVE NO WORDS FOR YOUR PRAISE
I JUST SAY THAT YOU ARE AWESOME
Thanks for your valuable feedback🙏
@@PKAnExcelExpert
🙏🙏🙏🙏🙏
Hi PK. Thank you so much for this! I have searched for a solution like this before, but never found anything as good as this. I have implemented this solution on a workbook I'm building right now and it works beautifully! I love your videos.
Thanks for your valuable feedback.
P.K, you're amazing! I use almost every tutorial and tip!!! Thank you and Congratulations for excellent work!
Thanks for your valuable feedback
I echo your words!
This is an ultimate module which really very helpful in many ways....I really appreciate your work and thank you so much....
From India sir, bow to you sir, greatest in the excel, god bless you sir, love you sir. great knowledge great work
Hi PK,
I am working in Aditya Birla Group in Dubai for past 4 years in Field of Excel Automation.
And i must appreciate you for the way you are explaining to the learners.
I usually do not see the basic videos but your thumbnail was too attractive to refuse.
Kudos to Excel.
Also in case you or any of your excel enthusiastic friend want to join for some role ill be happy to help.
From
Mudit Lalwani
Thanks for your valuable feedback
So long but good work thanks
Very helpful . Keep continue ur service. Ur expert👍
Sir ye to super se v uper h really you are a great teacher thank you
Great job
Thank you very much
Thank you very much for this great video and for this most amazing explanation.Thank you so much,Sir.
I did not enjoy this video, I LOVED it! Clear and concise explanation, very clever and useful tool. Thanks a lot!
Glad it was helpful!
Thank you very much Sir. Great Teacher for excel.
Thanks for your valuable feedback
Exactly what I was looking for. Awesome. I have put it to good use. Thx and keep them coming 👍🏻
Thanks for your valuable feedback
That was absolutely AMAZING!!!!!!! thank you so much. I learned tons :)
Thanks for your valuable feedback
Great work Ji
Thanks for your valuable feedback
thank you, its work.
Most welcome
How can I change the code to show more than 7 rows in the search list ? I would like to see 10 or more rows in the search box. Keep up the good work... your tutorials are very helpful. Thank You.
Thank you so much for the video, it really helped
can it be possible for an option to add data in some queue while searching from list which later can be added at once on that column . If yes, what changes should be needed the logic
It is really good tutorial keep it up
But I think you can two changes in it
1. Use unload form1 instead of form1.hide
2. When form height is 164 then tabstop of radio buttons will be false also or frame may be visible = false.
Otherwise tab key will effect radio buttons value.
superb sir. How to use sumif formula in vba? I will be grateful if you provide me video on this topic.
Oh! Thank you sharing! my true king vba code PK!
VERY GOOD IDEA
Sir now I am making excel userform for my own office
can we use this in my combobox in userform
thanks for help
Thanks PK
Excellent sir
How can change the direction to be (right) is the default, thank you.
I found a solution, thanks
sir you are really awesome
Thanks for your valuable feedback
@@PKAnExcelExpert sir how can i open a userform without opening excel or vba please sir help me
Excellent
PK , It is really A good one. It is very helpful. But explaining is too fast
Excellent sir
Thanks for your valuable feedback
Thanks.
You're welcome
That is amazing! Thank you for sharing this. My code is giving me an error "Next without For" in the Sub Refresh_List. I don't know how to fix it. It is looking the same as yours.
Very nice video
Can you provide us one vba userform related by medical pathology lab
If I share the workbook for multiple user to work on it, for example sharing on DropBox will it work on other PCs if they press crtl+m ?
Also, what codes to add if I press esc key in Keyboard, and the form will be closed.
Sir
use autofilter in excel vba to filter by date & time
Sir, how can I write in TextBox1 something other than drop-down menus?
PK sir, can you make it instead to take you to next available drop rather than right or down?
Hi
I am regular follower of your videos. Recently I had a universal search list box from the model you have shown. I had made some minor tweaks into it. But right now I'm facing a problem with a program.
Let me first mention the tweaks which I had made.
1. I had entered a code whereby the search box will automatically popup each time I select a cell in Column A
2. When the search box appears the focus should be on the text box so that the user can immediately enter the data rather than manually clicking the text box.
3. Once the user enters data in column A the cursor selection moves to the cell right to the current cell. That is once I enter data in suppose Column A3 the cursor would move to Column B3
And now the problem:
Once I type the keywords and I would select the particular item using down arrow key.
The cursor as intended moves to the right. But then it sort of gets locked. I couldn't enter any data in the now active cell until I would manually double click the cell which voids the utility of using this workbook since it would consume time If I had to click the cell each and every time.
Please let me know if there is a way to resolve this issue.
Is it possible to use in another userform combobox?
Good PK
Thanks for your valuable feedback
Espectacular
Thanks for your valuable feedback
thanks,I want this form to only work in one column and as soon as I stand on one of the column cells the form will activate
Mr. Ok,Ur guidance is amezzz.
Kindly need automate data entry Excell to web. Is this possible??
Thanks for your valuable feedback. I will upload such video very soon.
I'm working in Pvt automobile company, I'm doing more than 500 customer details update to vahan transport (RTO)website per month, I'm waiting for your vedio, thanks a lot Mr.
I want to know how to create button switch keyboard language in excel vba(by clicking on button no need by clicking shift +alt)
wonderful video.. very informative.. I want know you define arr ()
Super work, it's very useful for me.
I M working in MS 2010 on big data say avg 20000 rows & 28 columns in a sheet.
Is it work on MS 2010? Pls confirm me.
i want to imediately go to listbox1 after pressing enter or double click? please help on editing the code
Thanks
Welcome
This code / User form is working super exactly how I want, guide me How to AUTO* activate TEXT BOX on every stage of data entry.
will show it in next version
@@PKAnExcelExpert OK Thanks eager to watch the updated version.
Excel file is showing Error while saving the file "VBE6EXT.OLB could not be loaded " please guide to fix.
Document cannot be Saved.
Bhai mein excel mein new hun, kya aap meri madad kar sakte hai, mujhe invoice mein sirf ' item description" ke row mein chahye. Quantity aur rate dalne ke baad jab niche description mein cursor aye to automatically yeh pop ho. Can you make this for me. Bahot help milegi.
Hi, I have a question, the current searchbox is enable only 1 input in that cell, but I wish to input more than 2 selection in the cell by using the searchbox, is that possible? Thank you.
Super
Thanks for your valuable feedback
Hello sir, How can I make it dependent searchable???...
Can you make as searchable list for me,
Sir...am not getting meaning of Me. ??? Can u pls tell me the Purpose of Me. while writing code...???
Me has been used for current userform. Like textbox is the child property of userform. So you can use me.textbox1 or you can use userformname.textbox1
Thank u Sir....Ur way of explanation is so good....pls....Keep going on....!!!
16:21 sir! I'm getting an error "compyle error, block if without end if" even I have that end if on the same location also there you have in this video
is there any solution for it?
after doing some changes
16:22 "next without for"😭
One question, if we have a list box (data validation) it will be in a cell, then in VBA we can address that particular cell value ( D2 here).
i.e. =IFERROR(MATCH(D2.Value,CustID,0)+3,"")
How can this be done with Combo Box?
Basically I have Cust_ID & Cust_Name and I would like to get the Cust_ID or its row when I select a customer's name from a Combo Box?
How to contact you??
Sir can u please made vba which searchable drop-down list box open when i press a key and i search my data from it. In this video u have already drop down list in cell but my case cell is empty when i press shortcut key then search able drop down box open and i search my data from it
Sir can u please solve my problem..i want to search names data by name sound for ex ..if i have written name deepak in my data and if i forgot the spelling and i m writing dipak..then
my search fails..please help
Sir I tried all the steps shown by you ...from 2 am in night ...but on double click I didn't get results and in last you confused me by macro..😞☹️
How can you eliminate a persons name from the list once you have selected and used it?
I must be missing something, there is no vba code in the practice file - can anybody assist me?
Guess I must not be paying attention, I got lost in the speedy explanation.
Dear sir please
How to create invoice next video please help me sir
How To Create Searchable Drop Down List As Like Google Search Option?
Pls make videos in Hindi also
Excellent
Thank you so much 😀