I am an octogenarian having no formal computer education. I have prepared the same User Form after watching your video. First, I prepared the User Form following your step-by-step guide and then copied the VBA codes on my computer notepad. After overcoming the initial hiccups of navigating from one window to another window, and pasting the codes under different coding heads one after another, I have ultimately succeeded to prepare a perfectly working User Form. Thank you very much. God bless you.
@chanmonanrie68983 жыл бұрын
Thank you so much! Your instructions are so crystal-clear and are easy to follow. I successfully created my own UserForm and is now fully functioning. More power to you, Mr. Wizard!
@ExcelDestination3 жыл бұрын
Great to hear!
@dariatomashevskaia45733 жыл бұрын
Many thanks from Russian students!!! You helped us to comlete our assignment on Business Analitics in Excel
@ExcelDestination3 жыл бұрын
Glad it helped!
@woxz14 жыл бұрын
It's really what I'm looking for, presented in a very good way and simple. Thank you
@bhuapureducation38344 жыл бұрын
धन्यवाद भाई। मुझे आपका व्याख्यान बहुत पसंद आया। नए वीडियो जारी करने के लिए धन्यवाद
@vivekphadke165 жыл бұрын
Excellent, aptly simplified so that even a beginner comprehends. Thanks
@obbynomwa71434 жыл бұрын
Appreciated , this made my tracker be too easy, done updating details,search, clearing form and exit. Thanks , great tutorial
@ExcelDestination4 жыл бұрын
You're welcome!
@b3lg4r4th84 жыл бұрын
This is a great video for a basic spreadsheet/database and I shall utilise parts of it in future projects. What it doesn't cover, however, is updating a record. Do you have a similar video that covers updating records?
@user-fl1po9us8e Жыл бұрын
Thank you so much u saved my life, u have such clear instructions
@UncleBright5 жыл бұрын
Oh! What a quick response to my request. I was right when I said your channel is *my Final Destination* . Thank you so much .I will send you an email later. Once again ,may God bless you in abundance.
@ExcelDestination5 жыл бұрын
Thank you for your best wishes!!!
@osoriomatucurane95115 ай бұрын
Awesome Tutorial, Sir. For better readability you could have considered adding comments along the code, name the textboxes to be concise, descriptive and meaningful. Additional improvement could have been attained by assigning a variable such as wst to the object sheet1 as : Set wst = ThisWorkbook.sheets("sheet1") or using the sheet code.
@babulasabar90984 жыл бұрын
Thank you sir. Your tutoring us very easyly. Nice Sir. Long leave.Godbless you Sir.
@dinkarshinde372811 ай бұрын
Very simply method of learning
@diegorigl6 ай бұрын
Great Video, thank you, well explained, just one question, I am excel beginner so, how I can do all the same, but the first TextBox1 is a ComboBox1 so will show a list from the data, its that possible to do it
@markjosephramos80188 ай бұрын
Hi, your tutorial is awesome! what should I do if I'd like to edit it after I searched for it?
@patrickmartin20913 жыл бұрын
Thanks for this tutorial. It is exactly what I needed. Quick question...how would you code for a "replace data" button. That is to say, suppose you had a cell full of customer interaction notes. If I did a "Search and Display" for a current customer that would display the latest notes. After today's interactions I would like to add to the previous interaction notes within the same cell where they are now. This way I can keep a running log of appointment notes. All other fields would remain unchanged. Much appreciated
@ExcelDestination3 жыл бұрын
thanks for your comment! You can watch below given tutorial to learn VBA Code for Search Data and Update Date : kzbin.info/www/bejne/q4ivoXh6n7iSZpI
@shellykomar2 жыл бұрын
HI Great explanation and clear instructions. Thanks
@fafamar4 жыл бұрын
Hello sir, your tutorial is excellent. I've never tried VBA before and so far I find your tutorial easiest to understand. I would like to know additionally how to update/edit data after SEARCH and DISPLAY. May I also ask for a copy of your file? Thanks in advance!
@ExcelDestination4 жыл бұрын
send me email at EXCELDESTINATION@GMAIL.COM I will send you original file. for edit\update some different code would be required.......I will try to provide that code also while replying your email. Thanks
@UncleBright5 жыл бұрын
I have followed this tutoriral carefully and created a userForm with a all the command buttons and codes with success.Thank you once again. Sir,please I have other questions. (1) when I click on the DELETE Button, I would like to see a Message Box asking me *" you sure you want to delete"?* (2) Can we have another Button that can *Updates* any changes made to the data? (3) I managed to put a PDF file into a cell. How can I print it out with a help of a PRINT Button? Thank you!
@ExcelDestination5 жыл бұрын
I will create a tutorial for message box in VBA with all options................very soon! Keep watching
@mahledigitallearning58134 жыл бұрын
Excellent Sir.... you got one more subscriber!!!!!!!!!!!!!
@ExcelDestination4 жыл бұрын
Thank you so much!
@sukanyadhupkar50372 жыл бұрын
Indeed amazing tutorial! Thank you for explaining in detail. I just wanted to know whether is there any tutorial which will help me in creating a custom search form? I wanted to create a form which can take one or more values as input and after clicking on search button it should show all the matching results in the new sheet. It would be great help if you can share a video link! :)
@mikeheilig2 жыл бұрын
This is perfect for what I need to do. One thing I noticed is when I add data, it doesn't match the formatting in the table. For example, the font is different and it is not center aligned. Do you need more code to do that?
@brendanheslop50704 жыл бұрын
A good start for a novice. Thank you. One question - are you able to add data to empty cells at a later date. For instance if I don't have the 'AGE' when I enter the data, can I add this to the same row later. Thanks
@ExcelDestination4 жыл бұрын
yes we can do that.
@jigarshah88444 жыл бұрын
This is wonderful explanation. thank you so much. one question - If in the searched textbox. instead of text, I have hyperlink, is it possible to open that hyperlink?
@ExcelDestination4 жыл бұрын
yes, it is possible
@jigarshah88444 жыл бұрын
@@ExcelDestination can you help me with that?
@ahmedaseri3263 жыл бұрын
Thank you, sir, your tutorial is very good it helps me a lot can you please make print invoices, in the same user form
@ExcelDestination3 жыл бұрын
welcome
@jimmys41894 жыл бұрын
where u get cust_id is that from the first form you did? do you replace cust_id with label1? I did the code how u have it with cust_id and with label1 but when i play it the delete button doesn't do anything what am I doing wrong?
@dushmanthapriyadarshana98274 жыл бұрын
Great sir. Very easy to get
@ExcelDestination4 жыл бұрын
Thanks and welcome
@nirman4843 жыл бұрын
Thanks for your knowledgeable Video. but I hope this user form is only for Unique codes to be search means one of the primary key to be consider. How to display duplicate data I need to know?
@cindynel46142 жыл бұрын
Do you have a video to add next and previous buttons?
@fwmfwm3 жыл бұрын
It is nice tutorial, could you also show how to add the combo box and option box; check box; combo box and list box usage on the sample form ? Your help is much appreciated.
@ExcelDestination3 жыл бұрын
Please watch following tutorial to learn all specified things in UserForm : kzbin.info/www/bejne/fJ-tZqZ7ZdKSnsk
@fwmfwm3 жыл бұрын
@@ExcelDestination Thank you so much, it helps a lot.
@avinashavii42615 ай бұрын
Such a great explanation ❤️
@neeldeshmukh50424 жыл бұрын
Hi can you share the data which you used cause i have another data but for practice I can use this
@johng52952 жыл бұрын
Thanks in a million. Great content. Awesome. Grade: A++💥
@javedahmed83432 жыл бұрын
Highly useful
@ExcelDestination2 жыл бұрын
thanks
@jafarmiya92135 жыл бұрын
Superb Explanation Sir..... tnq, thq very much Sir
@nadimhossain59523 жыл бұрын
I want the ID cell (the one i searched in the employee id) selected or active. what will be the vba code then?
@KiaanandKiara4 жыл бұрын
This is a great video for beginners. Do you have the code if we add one more button Edit/Modify record?
@ExcelDestination4 жыл бұрын
send me email at exceldestination@gmail.com , I will provide you the file then you can modify that.
@adam50383 жыл бұрын
can i also pull up the information using customer name also to pull up customer id, customer age and city? or should i add something on the vba code under dim customer_id ? s that i can use customer name to pull up the information?
@BoodooIqbal2 ай бұрын
THANK YOU
@saggiboy3213 жыл бұрын
What if there is more than one search result. For e.g. searching for a student name, which can be more than one. how will we handle that. Can you please explain
@muhammadtaqi6437 Жыл бұрын
Excellent
@septie421 Жыл бұрын
Nice work, even though I copy everything from your tetorial , I get an error on this line, at buttons 1 and 3("Lastrow = Worksheets("Sheet1").Cells(Rows.Cont, 2).End(xlUp ).Row . It says application-defined or object-defined error (run-time error '1004') Can You help Please
@noureddinezenioui92435 жыл бұрын
Realy good job,your are a great teatcher
@vinaynimje974 жыл бұрын
i have data in excel sheets in various computers... i want to add button to transfer data of particular date range in Master sheet which is located in Google drive... thank you sir
@concepciones13864 жыл бұрын
Can I have the codes? there always an error.
@alvingapay25924 жыл бұрын
This tutorial is great, can you please make a part to update the details?
@ExcelDestination4 жыл бұрын
It is available at below link : kzbin.info/www/bejne/q4ivoXh6n7iSZpI
@darshanbhasin87204 жыл бұрын
Sir , This video is very useful , how can i add combobox in this userform? Please help me. Thanks
@ExcelDestination4 жыл бұрын
you can check another tutorial at following link : kzbin.info/www/bejne/pGjFiIp6ptaGrKs
@mahbubalam561992 жыл бұрын
would you please let me know, how to search through customer name ? Thanks Mahbub
@DineshKalel4 жыл бұрын
Hi Sir, Can you make a VBA Userfrom with upload attachments & Data saved to another file and attachment in specific folder with hyperlink in database file.
@ExcelDestination4 жыл бұрын
Will try
@DineshKalel4 жыл бұрын
@@ExcelDestination thanks for your prompt response.
@faysalalam6328 Жыл бұрын
very helpful tutorial. can you give me your example excel file
@TheJaebeomPark3 жыл бұрын
Wow it's clear
@shellykomar2 жыл бұрын
HI, I have done the same but can't seem working because I'm trying to search with reference no. and that in Sheet 1 but table start from f Colum F and and table start from row 6. Cheers
@ramjichauhan46694 жыл бұрын
Help full video sir
@greatlakeschorus68874 жыл бұрын
Do I need a unique Customer ID for record? Can I use Last Name instead so I can search it by last name
@ExcelDestination4 жыл бұрын
if there are more than one same last names, then it may consider only first matching record. So, I would suggest each row of data should have unique identity (customer id, or index number anything)
@wxmyjnsn4 жыл бұрын
instead of delete can you make it cut and paste to a table on a different sheet. Let say if record is no longer needed?
@ExcelDestination4 жыл бұрын
sure, I will create
@wxmyjnsn4 жыл бұрын
@@ExcelDestination THANK YOU! My data is in a table on sheet 1 I need to click button and move the selected data to a table on sheet 2.
@rakifhasanli40634 жыл бұрын
Thank you for the information, it was highly helpful. My question is about the Search and Display part of the Code. For example if there are several records for one Customer Id, which vba code I should use under the "Search and Display" command button?
@ExcelDestination4 жыл бұрын
there would be additional code required for that, however it would be simple code.
@rakifhasanli40634 жыл бұрын
@@ExcelDestination could you please tell what kind of code I should write? I need this as I am going to create report for myself in my work. Please help
@satishdeshpande13364 жыл бұрын
Dear Sir.. It is NICE Tutorial... Sir.. I've data in listbox containing 36 columns, I wound like to serch it or filtered it by typing customers name in text box... So pls suggest me code for this.. I am always watching your tutorial Vidio.. Waiting for your genuine reply Many Thanks...🙏
@ExcelDestination4 жыл бұрын
Satish Ji, there are many questions across my channel.....I try my best to respond all. I would request you to send me email for any support you need in Excel VBA. My email is EXCELDESTINATION@GMAIL.COM. Thanks again for your appreciation.
@granand3 жыл бұрын
Can we fetch data and store data from SQL in the excel form. The form is GUI and excel is front end and SQL as backend?
@ExcelDestination3 жыл бұрын
yes, we can do that, we need to connect sql with excel using reference in vba editor and in vba code.
@granand3 жыл бұрын
@@ExcelDestination I sent you email sir. Can you help me
@javediqbalahmadzai4 жыл бұрын
great effort!
@ExcelDestination4 жыл бұрын
Thanks!
@michaelsanares67574 жыл бұрын
I''m newbie about VBA but I find it interesting. Thanks for this wonderful tutorial Sir! However, I got a problem in coding the search and display button, even though I double-check it. It says application-defined or object-defined error (run-time error '1004') and the line has become yellow.
@ExcelDestination4 жыл бұрын
I can not say anything without looking into code. You can share your code at exceldestination@gmail.com
@satyasadhannag40042 жыл бұрын
Excellent
@septie421 Жыл бұрын
I'm getting the same problem here, did you find or get a solution.
@tamilarasans1185 Жыл бұрын
This excel sheet with userform
@alializadeh8195 Жыл бұрын
Thanks
@Knowledgehub43304 жыл бұрын
Tutorial is great. Bt in case picture put on the user form then hw to add pic.?
@ExcelDestination4 жыл бұрын
you can watch another tutorial to add picture on the user form. Link is : kzbin.info/www/bejne/d5XRiqmCatmcZ8k
@janixakem49364 жыл бұрын
hello please your assistance. i realized that for me to delete data on another sheet which is not the current sheet is not possible. how can i achieve this? thanks
@ExcelDestination4 жыл бұрын
Thanks for your comment. For any specific VBA requirement, you can write to exceldestination@gmail.com
@tissemsiltuniversity_econo7652 жыл бұрын
A+++ manyyyy thanks
@ExcelDestination2 жыл бұрын
Welcome
@ssinghvds3 жыл бұрын
thanks dear
@ExcelDestination3 жыл бұрын
Welcome 😊
@yasir57us3 жыл бұрын
how to allow user to change / edit some textbox?? not all
@ajdarji31544 жыл бұрын
Res sir, your form very simple and useful but VBA code for photo add,search and update button
@richardbuenaven75314 жыл бұрын
Your tutorial is very helpful.. I would to email you but I can't see your email or were I can email you.
@smartnations47284 жыл бұрын
Helpful
@computercoding1954 жыл бұрын
Hi can you share the the practice file
@NasarKhan-tv2cc2 ай бұрын
Cust_Id from where did you take this
@ajdarji31544 жыл бұрын
Sir,Accelent you program,thanks
@javedaslam82744 жыл бұрын
Pls show how to put update button in userform?
@ExcelDestination4 жыл бұрын
ok. Let me create new tutorial for that.
@indiandilip32564 жыл бұрын
It was Awesome sir can u plz upload a new video for vb script inward and outward stock search how much how many quantity available like that sir automobile plz sir canu do that sir
@ExcelDestination4 жыл бұрын
Thanks for your response! Actually I am not very much sure what you needed. However if you need any specific project in Excel VBA, you can always write to EXCELDESTINATION@GMAIL.COM Thanks again!
@doeumhongda4154 жыл бұрын
Hello Master. How to writer code don't allow duplicate id on add button. thank you!
@ExcelDestination4 жыл бұрын
Thanks Hongda Doeum for your comment! There is already one tutorial uploaded by me. I am sure that will help you. Link is : kzbin.info/www/bejne/r4G4dKtvfbmJrNE
@styleofmohan4 жыл бұрын
THANK YOU VERY MUCH.
@samsonm25793 жыл бұрын
How to add a list box to list all the value in form
@farhantareen87142 жыл бұрын
I am using your file in making my data base file but it has an error. can you help me.
@Parsiya_News4 жыл бұрын
Sir I want search data by help of combobox I have try many time but did not done plz help how can I serch vba by help of combobox like by date and shift A,B,C
@ExcelDestination4 жыл бұрын
please share your question at exceldestination. Thanks for watching.
@abuomardontadd2865 Жыл бұрын
thanks i got a warning yellow message that (cust_id ) object required please help
@vijaysahal45564 жыл бұрын
super 👍👍👍👍👍
@diannaloujazon55934 жыл бұрын
I have trouble in extracting information when you click a certain word. It's kinda hard how to find the program code of it.
@ExcelDestination4 жыл бұрын
send me email at exceldestination@gmail.com. Let me send you the original file.
@diannaloujazon55934 жыл бұрын
@@ExcelDestination Hi, thank you for noticing my comment. I already sent you an email! :)
@riteshpatel-yz7rd4 жыл бұрын
Hi ,I Am using Excel 2016 my problem is search code if statement syntax error show , please help me
@ExcelDestination4 жыл бұрын
Actually, you can use this code in any of excel version. Without looking at your code, It would be difficult to say anything. May be you can share the line, where error is occurring. I will try to reply.
@gerardvaneggermond99675 жыл бұрын
Hello, I have a question if I have the data under each other instead of side by side what do I do then?
@ExcelDestination5 жыл бұрын
some different\additional code would be required. You can send me your question at exceldestination@gmail.com with example
@rshabsough4 жыл бұрын
Thank you sir
@gladyssalvador93903 жыл бұрын
sir good day, ive been following your commands and its works so well. However I've been encountering this debug and i tried to use other command but it wont function.. I always ended up with this i = Application.Match(VBA.CLng(Me.cmbUpdateSupplier.Value), sh.Range("A:A"), 0)
@gladyssalvador93903 жыл бұрын
sir Help please : i = Application.Match(VBA.CLng(Me.cmbUpdateSupplier.Value), sh.Range("A:A"), 0) its debug
@hafizmudassaryasin19534 жыл бұрын
Please create Sr #, deleted, updated, data in specific worksheet with useform
@ExcelDestination4 жыл бұрын
ok
@muhammadtaqi6437 Жыл бұрын
How can I contact you for
@mirasheikh60713 жыл бұрын
Why it says debug on the lastrow coding?
@ksnarayanan24314 жыл бұрын
If customer ID is blank where to insert message "please complete the form"?
@ExcelDestination4 жыл бұрын
for that, you can use additional condition using VBA
@ksnarayanan24314 жыл бұрын
Thanks.
@ah.najeemnooran40752 жыл бұрын
How to add data in a new column wich we have Id and name already typed
@dandeman11484 жыл бұрын
Can we download the file anywhere to try
@ExcelDestination4 жыл бұрын
Hi Dan, Please send me email at exceldestination@gmail.com I will send you the original file. Thanks, Exceldestination
@nigelwhite81004 жыл бұрын
When I run the search it has an issue with the For i=2 to lastrow. What am i doing wrong?
@ExcelDestination4 жыл бұрын
I can suggest you only after looking at your VBA Code, you have developed (using)...
@abdelrhmanali374 жыл бұрын
thanks sir ineed this doc
@ExcelDestination4 жыл бұрын
let me check.........If I have this file, I will send it to you.
@saidammabejjam2784 жыл бұрын
All the data in the first sheet dated today should go into the second sheet. Similarly the data in the first sheet should be blank without data. Similarly the date should be changed the next day. The same amount of data should go into another sheet how to create
@ExcelDestination4 жыл бұрын
for any excel vba project, you can write to exceldestination@gmail.com , we are a freelancing team and can provide any vba code.
@saidammabejjam2784 жыл бұрын
Ok sir mail drop done plz check once
@rasheduzzamanrashed61853 жыл бұрын
i need the practice file
@joshuarichards43524 жыл бұрын
Can u pls write a code to update data in this useform?
@ExcelDestination4 жыл бұрын
Yes Sure, let me create a tutorial to search and update using UserForm.
@joshuarichards43524 жыл бұрын
Thank u sir
@usmanrafiq-x8q Жыл бұрын
Why You use the text boexs name as real to easily understand the strings in code.. declare the textbox 1 textbox 2 is not a proper way... txtProduct LblCity is more easily to understand withen the code with real coding .
@damienlee95704 жыл бұрын
thanks my Indian bro from Singapore, you help me pas my fucking fit vba test, treat you to a drink next time you come sg
@ExcelDestination4 жыл бұрын
Glad to help you in any of your VBA project.
@avdheshjadon33393 жыл бұрын
I'm getting error... Run time error '9': Subscript out of range
@ExcelDestination3 жыл бұрын
this error occurs when you use any object but it is not available. I would suggest to check spellings........and sheet name.