Hi, All of your video tutorials are very simple yet VERY POWERFUL and easy to follow! Hope you won’t stop doing this and sharing your knowledge! Keep it up and God bless you always…
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.
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!
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?
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.
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
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.
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!
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?
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
thanks for your comment! You can watch below given tutorial to learn VBA Code for Search Data and Update Date : ruclips.net/video/uWLpEDjS_00/видео.html
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?
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.
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!
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
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?
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?
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! :)
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
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
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
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?
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
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
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
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.
Thanks Hongda Doeum for your comment! There is already one tutorial uploaded by me. I am sure that will help you. Link is : ruclips.net/video/yPUCx9HTVvo/видео.html
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)
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.
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?
@@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
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...🙏
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.
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.
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
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
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!
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 .
Hi,
All of your video tutorials are very simple yet VERY POWERFUL and easy to follow! Hope you won’t stop doing this and sharing your knowledge! Keep it up and God bless you always…
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.
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!
Great to hear!
धन्यवाद भाई। मुझे आपका व्याख्यान बहुत पसंद आया। नए वीडियो जारी करने के लिए धन्यवाद
Many thanks from Russian students!!! You helped us to comlete our assignment on Business Analitics in Excel
Glad it helped!
Appreciated , this made my tracker be too easy, done updating details,search, clearing form and exit. Thanks , great tutorial
You're welcome!
Thank you so much u saved my life, u have such clear instructions
It's really what I'm looking for, presented in a very good way and simple. Thank you
Excellent, aptly simplified so that even a beginner comprehends. Thanks
Thank you sir. Your tutoring us very easyly. Nice Sir. Long leave.Godbless you Sir.
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?
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.
Thank you for your best wishes!!!
Very simply method of learning
HI Great explanation and clear instructions. Thanks
Excellent Sir.... you got one more subscriber!!!!!!!!!!!!!
Thank you so much!
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
Great sir. Very easy to get
Thanks and welcome
Superb Explanation Sir..... tnq, thq very much Sir
Hi, your tutorial is awesome! what should I do if I'd like to edit it after I searched for it?
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.
Thanks in a million. Great content. Awesome. Grade: A++💥
Such a great explanation ❤️
Thank you, sir, your tutorial is very good it helps me a lot can you please make print invoices, in the same user form
welcome
Realy good job,your are a great teatcher
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!
I will create a tutorial for message box in VBA with all options................very soon! Keep watching
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?
Hi can you share the data which you used cause i have another data but for practice I can use this
Do you have a video to add next and previous buttons?
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
thanks for your comment!
You can watch below given tutorial to learn VBA Code for Search Data and Update Date :
ruclips.net/video/uWLpEDjS_00/видео.html
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?
yes, it is possible
@@ExcelDestination can you help me with that?
I want the ID cell (the one i searched in the employee id) selected or active.
what will be the vba code then?
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.
Please watch following tutorial to learn all specified things in UserForm :
ruclips.net/video/FnJ5sE0m_hg/видео.html
@@ExcelDestination Thank you so much, it helps a lot.
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!
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
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?
Highly useful
thanks
This is a great video for beginners. Do you have the code if we add one more button Edit/Modify record?
send me email at exceldestination@gmail.com , I will provide you the file then you can modify that.
how to allow user to change / edit some textbox?? not all
This tutorial is great, can you please make a part to update the details?
It is available at below link :
ruclips.net/video/uWLpEDjS_00/видео.html
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?
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! :)
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
very helpful tutorial. can you give me your example excel file
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
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
yes we can do that.
Can I have the codes? there always an error.
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?
sure, I will create
@@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.
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?
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
Thanks for your comment. For any specific VBA requirement, you can write to exceldestination@gmail.com
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
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?
yes, we can do that, we need to connect sql with excel using reference in vba editor and in vba code.
@@ExcelDestination I sent you email sir. Can you help me
Sir , This video is very useful , how can i add combobox in this userform?
Please help me. Thanks
you can check another tutorial at following link :
ruclips.net/video/n7bWWDqqSvI/видео.html
How to add a list box to list all the value in form
Excellent
Hi can you share the the practice file
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
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.
Will try
@@ExcelDestination thanks for your prompt response.
Sir,Accelent you program,thanks
thanks
i got a warning yellow message that (cust_id ) object required please help
Hello Master. How to writer code don't allow duplicate id on add button. thank you!
Thanks Hongda Doeum for your comment! There is already one tutorial uploaded by me. I am sure that will help you. Link is :
ruclips.net/video/yPUCx9HTVvo/видео.html
THANK YOU
Help full video sir
would you please let me know, how to search through customer name ?
Thanks
Mahbub
Cust_Id from where did you take this
How to add data in a new column wich we have Id and name already typed
Pls show how to put update button in userform?
ok. Let me create new tutorial for that.
Do I need a unique Customer ID for record? Can I use Last Name instead so I can search it by last name
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)
Hi ,I Am using Excel 2016 my problem is search code if statement syntax error show , please help me
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.
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?
there would be additional code required for that, however it would be simple code.
@@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
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...🙏
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.
I am using your file in making my data base file but it has an error. can you help me.
Why it says debug on the lastrow coding?
great effort!
Thanks!
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.
I can not say anything without looking into code. You can share your code at exceldestination@gmail.com
Excellent
I'm getting the same problem here, did you find or get a solution.
This excel sheet with userform
Tutorial is great. Bt in case picture put on the user form then hw to add pic.?
you can watch another tutorial to add picture on the user form. Link is :
ruclips.net/video/AdnYvL5ti1g/видео.html
Res sir, your form very simple and useful but
VBA code for photo add,search and update button
I have trouble in extracting information when you click a certain word. It's kinda hard how to find the program code of it.
send me email at exceldestination@gmail.com. Let me send you the original file.
@@ExcelDestination Hi, thank you for noticing my comment. I already sent you an email! :)
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
please share your question at exceldestination. Thanks for watching.
thanks dear
Welcome 😊
sir Help please :
i = Application.Match(VBA.CLng(Me.cmbUpdateSupplier.Value), sh.Range("A:A"), 0) its debug
Wow it's clear
If customer ID is blank where to insert message "please complete the form"?
for that, you can use additional condition using VBA
Thanks.
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
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!
super 👍👍👍👍👍
Thanks
i need the practice file
Hello, I have a question if I have the data under each other instead of side by side what do I do then?
some different\additional code would be required. You can send me your question at exceldestination@gmail.com with example
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 .
A+++ manyyyy thanks
Welcome
Please create Sr #, deleted, updated, data in specific worksheet with useform
ok
Can we download the file anywhere to try
Hi Dan, Please send me email at exceldestination@gmail.com I will send you the original file. Thanks, Exceldestination
How can I contact you for
Your tutorial is very helpful.. I would to email you but I can't see your email or were I can email you.
Can u pls write a code to update data in this useform?
Yes Sure, let me create a tutorial to search and update using UserForm.
Thank u sir
When I run the search it has an issue with the For i=2 to lastrow. What am i doing wrong?
I can suggest you only after looking at your VBA Code, you have developed (using)...
THANK YOU VERY MUCH.
Helpful
Doesn't work for me I receive an error
Thank you sir
Please send me this.. I wish you added edit button..
thanks sir ineed this doc
let me check.........If I have this file, I will send it to you.
I'm getting error...
Run time error '9':
Subscript out of range
this error occurs when you use any object but it is not available. I would suggest to check spellings........and sheet name.