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!

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.

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

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?

Appreciated , this made my tracker be too easy, done updating details,search, clearing form and exit. Thanks , great tutorial

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.

Many thanks from Russian students!!! You helped us to comlete our assignment on Business Analitics in Excel

धन्यवाद भाई। मुझे आपका व्याख्यान बहुत पसंद आया। नए वीडियो जारी करने के लिए धन्यवाद

Thank you sir. Your tutoring us very easyly. Nice Sir. Long leave.Godbless you Sir.

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

Realy good job,your are a great teatcher

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! :)

Excellent Sir.... you got one more subscriber!!!!!!!!!!!!!

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

Superb Explanation Sir..... tnq, thq very much Sir

HI Great explanation and clear instructions. Thanks

Thank you so much u saved my life, u have such clear instructions

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?

Thanks in a million. Great content. Awesome. Grade: A++💥

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!

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?

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

This is a great video for beginners. Do you have the code if we add one more button Edit/Modify record?

Hi, your tutorial is awesome! what should I do if I'd like to edit it after I searched for it?

THANK YOU VERY 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

Sir,Accelent you program,thanks

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!

Hi can you share the data which you used cause i have another data but for practice I can use this

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?

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?

Do you have a video to add next and previous buttons?

Great sir. Very easy to get

Such a great explanation ❤️

Very simply method of learning

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.

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?

great effort!

Help full video sir

I want the ID cell (the one i searched in the employee id) selected or active. what will be the vba code then?

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?

Excellent

Wow it's clear

Thank you, sir, your tutorial is very good it helps me a lot can you please make print invoices, in the same user form

Sir , This video is very useful , how can i add combobox in this userform? Please help me. Thanks

hi! must the data in the excel sheet be in continuous column for this to work? cause my vba is not responding and giving me the data

This tutorial is great, can you please make a part to update the details?

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.

Highly useful

Tutorial is great. Bt in case picture put on the user form then hw to add pic.?

Do I need a unique Customer ID for record? Can I use Last Name instead so I can search it by last name

Can I have the codes? there always an error.

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

Hello, I have a question if I have the data under each other instead of side by side what do I do then?

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

Thank you sir

Your tutorial is very helpful.. I would to email you but I can't see your email or were I can email you.

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

Helpful

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

A+++ manyyyy thanks

thanks dear

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?

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.

Hello Master. How to writer code don't allow duplicate id on add button. thank you!

super 👍👍👍👍👍

Res sir, your form very simple and useful but VBA code for photo add,search and update button

how to allow user to change / edit some textbox?? not all

How to add a list box to list all the value in form

Hi can you share the the practice file

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.

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?

thanks sir ineed this doc

thanks i got a warning yellow message that (cust_id ) object required please help

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

How to add data in a new column wich we have Id and name already typed

Please create Sr #, deleted, updated, data in specific worksheet with useform

When I run the search it has an issue with the For i=2 to lastrow. What am i doing wrong?

Pls show how to put update button in userform?

Hi ,I Am using Excel 2016 my problem is search code if statement syntax error show , please help me

Why it says debug on the lastrow coding?

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

sir Help please : i = Application.Match(VBA.CLng(Me.cmbUpdateSupplier.Value), sh.Range("A:A"), 0) its debug

would you please let me know, how to search through customer name ? Thanks Mahbub

i need the practice file

I am using your file in making my data base file but it has an error. can you help me.

very helpful tutorial. can you give me your example excel file

I have trouble in extracting information when you click a certain word. It's kinda hard how to find the program code of it.

Can we download the file anywhere to try

How to add pic in userform

Sir i need this file can u share me pls

If customer ID is blank where to insert message "please complete the form"?

I'm getting error... Run time error '9': Subscript out of range

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

Can u pls write a code to update data in this useform?

How can I contact you for

Doesn't work for me I receive an error