Dear Mr. Takyar, I don't know where in the world you are located but sometimes it seems you are in my office, reading my projects to-do lists. Once more you have shared a few things that I will need to implement in the short term. I can't thank you enough for all that you share and teach. I have been able to make miracles happen in the company with the contents that I learn from you. Thank you, once more. May God bless you. :-)
Mr. Takyar sir, you are always solving my ideas. Whenever i tried to make a way i always see your methods very helpful sir. Love your tutorials as always your humble fan.
Sir how about user form in combo box then the vlookup list sheet or if index with show in combo box selection from once select the following text boxes blank will be filled with the information or I mean the select in combo will fill the following blank and if we save it the information will be save to other sheets. Hope you see this comment. Thanks in advanced.
Hi, it all worked been able to select information on the combo box and populate all other boxes. but need to be able to submit changes, i have created a button to Update record, ID staying the same, but to replace any data on the other text& combo boxes as example may need to amend "attendance" or "Marks" for each of the ID's to update my form.
Hello. I have copied exactly as your example, leaving even the naming as in yours. I have tried with my requirements. I keep getting an error at the last row line. Any solutions for this error. Thank you. You video is perfect for what I am in need of. Thank you.
Hi Dinesh What if I wanted to get the information from another workbook (example) c:\users\customers.xlsx? and fill the textboxes in that userform on the first workbook Thank you
Open the workbook: Workbooks.Open ("C:\Users\takyar\Desktop\test-user-form-2.xlsx") Use, for example , this code for the command button on the user-form: TextBox1.Text = Workbooks("test-user-form-2.xlsx").Sheets("sheet1").Range("A2") to get data from Range("A2") in the second workbook into the user-form in the first workbook. Of course, you have to use your paths.
Hello, the video is very helpful. The text will only get filled in if the combobox is a number. How can I have text fill in if the combo box begins with a letter or word?
@@Exceltrainingvideos thanks, is there any way to allow for number and letters? I am applying this form with part numbers. Some Of these part numbers begin with letters and some begin with numbers.
hi thank you for your explanation , i have problem with compile error invalid use of me keyword if me.combobox1..value= ws.cells(i,"b") i did all the code you did but dosent work with me can you help me thanks
Hello sir Your video is very useful and knowledgeable. Please help me to solve my query to as I have combobox and some text boxes on userform. I want a code if I selected the value from combobox then the data which I fill in text boxes will enter in the selected item row from combobox. Eg if I select apple (A1) from combobox then the value of text box will add in B1. Please let me know if you want some screenshot of my userform
These links will help: www.exceltrainingvideos.com/fill-text-boxes-on-user-form-based-on-selection-in-combobox/ www.exceltrainingvideos.com/capture-data-from-userform-to-excel-worksheet/ www.exceltrainingvideos.com/advanced-user-form/ Or search www.exceltrainingvideos.com
Dear Sir.. I've query about excel vba.. I've have data in listbox containing 36 columns... would like to filter or serch by entering character in relative textbox.. Sir how it is possible pls suggest me... Waiting for your genuine reply... Thanks...
These links will guide: www.exceltrainingvideos.com/display-data-in-listbox-based-on-combo-box-selection/ www.exceltrainingvideos.com/design-user-form-with-listbox-labels-textboxes-optionbuttons-command-button/ www.exceltrainingvideos.com/populate-list-box-text-box-with-excel-data-using-vba/ www.exceltrainingvideos.com/customer-inventory-query-interface-using-userform/ Or search www.exceltrainingvideos.com or my TH-cam channel.
@@Exceltrainingvideos Thank you but what I'm really trying to do is to avoide copying the access table in excel, I have the code to show the information in combobox directly from access but I can't make that the textbox shows the data based in combobox selection. It would be very interesting for a video because there is no much information about it.
The link to this Excel VBA tutorial with a downloadable sample file for practice will help: www.exceltrainingvideos.com/tag/fill-text-box-controls-with-data-from-worksheet-based-on-combobox-selection/
Sir, I want the User form with the selection in a combobox from excel Worksheet and enter data of other text boxes to Excel Worksheet. Kindly help me in this regard
@@Exceltrainingvideos let say i have 3 dependent combo boxes. Like combo box 2 is dependent with combo box 1,combo box 3 is depended with combobox 2. After selecting all those combo boxes, can the 4th box (either a list box or text box) get the result based on the selected combo boxes?
HI Sir, Can you please explain the same code by creating the text boxs( firs name, second name and all ) in run time. I need same action i.e., by getting the data to text boxs depending on combo box selection
hello sir,please give me solution for following question how to give multiple selection in combobox and display multiple selection description in textbox?
Salam sir. Sir i wanna Userform in which we add the subject name of a student thru combobox then add the roll no.of the student in taxtbox and then we add the obtained marks of the student. His marks will be automatically added in the work sheet before the student name and roll no.
please Can you help me with my excel file. I tried to find the problem cause the userform doesn’t fill automatically coud you give me you gmail to send you the file?
These links will help find a solution: www.exceltrainingvideos.com/get-data-from-random-check-boxes-into-excel-worksheet/ www.exceltrainingvideos.com/inventory-management-with-userforms/
This code worked perfectly until I tried to apply this same code with a different sheet in my workbook. I have a workbook with multiple sheets. I have created one userform with muti-pages.
Dear Mr. Takyar, I don't know where in the world you are located but sometimes it seems you are in my office, reading my projects to-do lists. Once more you have shared a few things that I will need to implement in the short term. I can't thank you enough for all that you share and teach. I have been able to make miracles happen in the company with the contents that I learn from you. Thank you, once more. May God bless you. :-)
Mr. Takyar sir, you are always solving my ideas. Whenever i tried to make a way i always see your methods very helpful sir. Love your tutorials as always your humble fan.
Thanks for explaining this, your logic and methodology are exceptionally clean.
I'm just amazed in the way you explaining the logic of every code, such a very detailed explanation. Thank you new subs here
I am amazed to see how many questions I ask myself are already answered on the internet. Thanks for the video, super useful.
Thanks. Please share with your friends too.
Thank you very much for sharing this information. This is exactly what I was looking for a long time. God Bless you.
Sir how about user form in combo box then the vlookup list sheet or if index with show in combo box selection from once select the following text boxes blank will be filled with the information or I mean the select in combo will fill the following blank and if we save it the information will be save to other sheets. Hope you see this comment. Thanks in advanced.
Hi, it all worked
been able to select information on the combo box and populate all other boxes.
but need to be able to submit changes, i have created a button to Update record, ID staying the same, but to replace any data on the other text& combo boxes
as example may need to amend "attendance" or "Marks" for each of the ID's to update my form.
Just type 'update' in the search box in my channel to view a number of Excel VBA solutions.
this is very helpful. thank you so much for sharing your knowledge :)
Hello. I have copied exactly as your example, leaving even the naming as in yours. I have tried with my requirements. I keep getting an error at the last row line. Any solutions for this error. Thank you.
You video is perfect for what I am in need of. Thank you.
You can download a sample file here www.exceltrainingvideos.com/fill-text-boxes-on-user-form-based-on-selection-in-combobox/
Hi Dinesh
What if I wanted to get the information from another workbook (example) c:\users\customers.xlsx? and fill the textboxes in that userform on the first workbook Thank you
Open the workbook:
Workbooks.Open ("C:\Users\takyar\Desktop\test-user-form-2.xlsx")
Use, for example , this code for the command button on the user-form:
TextBox1.Text = Workbooks("test-user-form-2.xlsx").Sheets("sheet1").Range("A2")
to get data from Range("A2") in the second workbook into the user-form in the first workbook.
Of course, you have to use your paths.
Hello, the video is very helpful. The text will only get filled in if the combobox is a number. How can I have text fill in if the combo box begins with a letter or word?
This link will help: www.exceltrainingvideos.com/fill-text-boxes-on-user-form-based-on-selection-in-combobox/
@@Exceltrainingvideos thanks, is there any way to allow for number and letters? I am applying this form with part numbers. Some Of these part numbers begin with letters and some begin with numbers.
hi thank you for your explanation , i have problem with compile error invalid use of me keyword
if me.combobox1..value= ws.cells(i,"b") i did all the code you did but dosent work with me can you help me thanks
Hello sir
Your video is very useful and knowledgeable. Please help me to solve my query to as I have combobox and some text boxes on userform. I want a code if I selected the value from combobox then the data which I fill in text boxes will enter in the selected item row from combobox. Eg if I select apple (A1) from combobox then the value of text box will add in B1. Please let me know if you want some screenshot of my userform
These links will help:
www.exceltrainingvideos.com/fill-text-boxes-on-user-form-based-on-selection-in-combobox/
www.exceltrainingvideos.com/capture-data-from-userform-to-excel-worksheet/
www.exceltrainingvideos.com/advanced-user-form/
Or search www.exceltrainingvideos.com
Dear Mr, How about it if using Named Ranges every "A,B,C,D" column..?
Would you be able to teach me..🙏
Sorry my english is so bad..
Dear Sir..
I've query about excel vba..
I've have data in listbox containing 36 columns... would like to filter or serch by entering character in relative textbox..
Sir how it is possible pls suggest me...
Waiting for your genuine reply...
Thanks...
These links will guide: www.exceltrainingvideos.com/display-data-in-listbox-based-on-combo-box-selection/
www.exceltrainingvideos.com/design-user-form-with-listbox-labels-textboxes-optionbuttons-command-button/
www.exceltrainingvideos.com/populate-list-box-text-box-with-excel-data-using-vba/
www.exceltrainingvideos.com/customer-inventory-query-interface-using-userform/
Or search www.exceltrainingvideos.com or my TH-cam channel.
Hi, Do you know how to do this in an excel form but with data from an access table?
The link to this Excel VBA tutorial will guide: www.exceltrainingvideos.com/get-data-from-access-database-using-excel-vba/
@@Exceltrainingvideos Thank you but what I'm really trying to do is to avoide copying the access table in excel, I have the code to show the information in combobox directly from access but I can't make that the textbox shows the data based in combobox selection. It would be very interesting for a video because there is no much information about it.
The link to this Excel VBA tutorial with a downloadable sample file for practice will help: www.exceltrainingvideos.com/tag/fill-text-box-controls-with-data-from-worksheet-based-on-combobox-selection/
Sir, I want the User form with the selection in a combobox from excel Worksheet and enter data of other text boxes to Excel Worksheet. Kindly help me in this regard
Hi Sir, Good day!
I was wondering can i produce the result in 1 textbox by using multiple combobox?
Why don't you try it out? Can you share what you are exactly trying to achieve?
@@Exceltrainingvideos let say i have 3 dependent combo boxes. Like combo box 2 is dependent with combo box 1,combo box 3 is depended with combobox 2. After selecting all those combo boxes, can the 4th box (either a list box or text box) get the result based on the selected combo boxes?
I failed thousand times to do this one. can you send me your excel file?
HI Sir,
Can you please explain the same code by creating the text boxs( firs name, second name and all ) in run time. I need same action i.e., by getting the data to text boxs depending on combo box selection
hi SIr. can I get the excel file. I tried for 2months the vba code but impossible to succeed
This link will help: www.exceltrainingvideos.com/fill-text-boxes-on-user-form-based-on-selection-in-combobox/
@@Exceltrainingvideos thank you
i am getting runtime error 9 subscript out of range ? any idea where it is impacting
Sheet references are wrong.
hello sir,please give me solution for following question
how to give multiple selection in combobox and display multiple selection description in textbox?
Better to use a list-box.
Salam sir.
Sir i wanna Userform in which we add the subject name of a student thru combobox then add the roll no.of the student in taxtbox and then we add the obtained marks of the student.
His marks will be automatically added in the work sheet before the student name and roll no.
This link will help: th-cam.com/video/yLyPe_M1sNc/w-d-xo.html
Or search www.exceltrainingvideos.com
why i am not getting anything in dropdown when i run macro, i see no error but no data in dropdown but i have data in Database for that matter?
Check your code carefully. If in doubt, watch the video again to see where you are going wrong.
please Can you help me with my excel file. I tried to find the problem cause the userform doesn’t fill automatically
coud you give me you gmail to send you the file?
takyardinesh@gmail.com
Not sure why text boxes are not populating after selection in combo box. I wrote the same code..
Thank you sir
How to get selected checkboxes value displayed in textbox?
These links will help find a solution:
www.exceltrainingvideos.com/get-data-from-random-check-boxes-into-excel-worksheet/
www.exceltrainingvideos.com/inventory-management-with-userforms/
Sir I Have One Question
This code worked perfectly until I tried to apply this same code with a different sheet in my workbook. I have a workbook with multiple sheets. I have created one userform with muti-pages.
Just activate the sheet first where you want the data to go.
Please Adjust the volume while uploading the video , as your content is good but voice is too much low.
OK
Ditto