HomeОбразованиеRelated VideosMore From: Dinesh Kumar Takyar

Adding and using a combobox on a userform in MS-Excel

329 ratings | 214819 views
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com You can add a combo-box to your user-form to amke data entries easier. Once the data is entered, the calculations can be automated and the data transferred to the Excel worksheet. Link to website: http://www.familycomputerclub.com/adding-using-combobox-on-userform.html Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Html code for embedding videos on your blog
Text Comments (48)
Pietro Gazzera (2 months ago)
Thank you
Malshan Nimsara (3 months ago)
it was really good video
Michael Gonsalves (4 months ago)
very helpful Dinesh , consice and to the point thank you
Subhajit Dey (1 year ago)
Sir is it possible to write a text in drop down list which is automatic updated in row source?
Subhajit Dey (1 year ago)
No, not yet.. I will
Dinesh Kumar Takyar (1 year ago)
Did you try writing text in a list-box? Was it possible?
Cesar Ln (1 year ago)
Your videos are always great and I appreciate your detailed explanation on how to do something. I was wondering if you would show a video on how to add a combo box in a userform and then assign a macro to each item on the combo box list. I am trying to create a combo box with a list of different links to web sites. I have created the code from your other video "How to login to a web site automatically" and I would like to run that macro for each web site site selected from the drop down list
Dinesh Kumar Takyar (1 year ago)
http://www.exceltrainingvideos.com/tag/how-to-populate-combo-box-automatically/ https://www.exceltrainingvideos.com/populate-combo-box-on-excel-userform-with-unique-items-using-vba/ https://www.exceltrainingvideos.com/sort-combobox-data-using-vba/ https://www.exceltrainingvideos.com/excel-vba-combobox-match-required/ https://www.exceltrainingvideos.com/filter-data-in-combo-box/ So you see it's a good idea to read the description accompanying the video, search my website https://www.exceltrainingvideos.com or my YouTube channel: https://goo.gl/5Jx1NP
importedmusic (1 year ago)
This is awesome, isn't it?
Rehna Joseph (1 year ago)
please make a video of combo box dependency in visual basic 6.0
Dinesh Kumar Takyar (1 year ago)
This link will help: http://www.exceltrainingvideos.com/tag/create-dependent-combo-boxes-in-excel-user-form-with-vba/
Nou Bopha (2 years ago)
Thank so much it's very helpful.
Alan Fredericks (2 years ago)
I am trying to create a txtbox to input xxx.xx into =English(xxx.xx) I already have the code to convert number to Text. It works flawlessly. Great for printing checks. I just would like an input form, and not having to type in the (parentheses). This should be easy, but I just can figure it out.
Tim Dent (2 years ago)
Didn't work when I tried it. Mr. Takyar must've left out a few important steps.
Crystal Nicolle Ambray (3 years ago)
how did u offset sir? whats the complete code?
Dinesh Kumar Takyar (3 years ago)
+crystal nicolle ambray This link might help: http://www.familycomputerclub.com/adding-using-combobox-on-userform.html
Wihann Mouton (3 years ago)
Isn't it ?
czarina keith (3 years ago)
THANK YOU VERY MUCH!
Guy Reading (3 years ago)
Hi Dinesh. Good video! Just a note, when you say, "isn't it?", it would be more appropriate to say, "won't we?". When someone wants to talk about how an object works, we could say, "isn't it". So you could say, "This is how it works, isn't it?". However a lot of the time you say things like, "we will need to change the code", in which case, saying, "we will need to change the code, won't we?" would be more appropriate!
Dinesh Kumar Takyar (3 years ago)
+Guy Reading Thank you!
Ansie Smit (3 years ago)
Thank you for simplifying the process so that even I can do it
Ansie Smit (3 years ago)
+Dinesh Kumar Takyar  Can you maybe help me, I have created a multipage input sheet for auditing with 100+ fields (textboxes; option buttons & comboboxes). 1) BUT with so many fields I need code for my control OK button to "complete all fields" before it loads the data into my database.2) I would also like if my control OK button can automatically clear all data from the input sheet so that I can start on a clean slate with each input. 3) Pushing my luck now I would also like to also create a review control button that gives me the option to displays all the data before loading it onto my database. Any help would be appreciated!
Dinesh Kumar Takyar (3 years ago)
+Ansie Smit  Thank you!
GoldenBrown091 (3 years ago)
Thank you thank you thank you
Easy Life (3 years ago)
How to add Zeroes before numbers in MS Excel https://www.youtube.com/watch?v=3UbDTWafn7Q
Undine Duke (4 years ago)
Hi every time I try to do the reference list for the combo box I keep getting the following error "You must enter a valid reference you want to go to, or type a valid name for the selection"  Can you please assist.
Azad Bakirli (4 years ago)
thank you so much. you great man... god bless you!
kalpa wijesinghe (4 years ago)
your all vedeo is ver good i need to know one thing please give me email i will sand what i make user form and what i need to add. My emai [email protected] Tanks
RAJESH MAJETHIA (4 years ago)
thank you very easiest way to learn
Martin Georgiev (5 years ago)
Thank you so much!!! :)
Pedro Otico (5 years ago)
Hi Sir, is there any codes that says the time i received my email. And paste is to a worksheet. If its possible, can you me how. Much appreciated sir. Good day.
Ally Ally (5 years ago)
thank you
dubaiabud2000 (5 years ago)
Isn't it!!!
Mateusz Pawlaczyk (5 years ago)
it's killing me, isn't it? Anyway thx for upload this video.
Jogendra Nath Barma (5 years ago)
please help me how to code in the salary table?
Kanna Raju (5 years ago)
thanks
MUNEER JUBYER (5 years ago)
Dear Sir, Let me thank you for your useful and helpful training, I really appreciate your kindness assistance in this regards, Looking forward to your recent video training, Thank you very much Muneer
Dinesh Kumar Takyar (6 years ago)
Check the link in the description.:
Lou T (6 years ago)
Hi. Great VBA video. Thank you for sharing. I was trying to duplicate your macro but parts of it was cut off from the screen while you you were going through it. I was wondering if you would be willing to help me put the pieces together so that I can try learn what each piece does. - One line was..... RowCount = Worksheets("Sheet1").Range("A4").current??? I believe it was around row 18. Thank you very much for your help....
Sravan Kumar Nani (6 years ago)
Thanks
CharlesinChargex12 (6 years ago)
At time 3:54 where it says RowCount = Worksheets("Sheet1").Range("A4").Current????? what is the ending part of that code dealing with Current?
Cynthia A (6 years ago)
performed the first record and goes well when I insert the second record adds in the same row of the first as I can do
atul augustine (6 years ago)
thank u so much :)
polosbest (6 years ago)
we can't see all data(the syntax ), there is a way that you can show it?
Ch Youness (6 years ago)
thanks
Bryan Fernandez (6 years ago)
I followed everything you've done but when I want to run it the, benefits = txtSalary.Value * 0.5 was highlighted in yellow that means its error but it is exactly the same as the code you made.Can you please tell me why and what should I do to correct it. thanks a lot
test123ok (6 years ago)
@salamancaestudiocesa isn't it ?
Cesar Villafuerte (7 years ago)
Thanks, you are the best

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.