Excel VBA UserForm | Add Data | Reset | Exit | Search | Update | Delete | 

Thank You! Thank You! Faced with an unimaginable deadline, and at least 5 years since I last looked at VBA, I was able to follow your entire tutorial and re-produce the whole project and modify it to fit our needs. You made me look like a rock star! Thank you!!

time table : @3:42 create the data result sheet in the output excel file @6:32 creating the form @16:38 putting option in the drop down list @18:37 programing the save button " coding the collection of text boxes input and export the data to excel output sheet and the table viewer in the form " @22:50 the code for the programing the excel output sheet name and the error message box to warn the user there is a fault in the input @24:05 adding the data to excel output sheet @28:21 emptying the text boxes after the input is done @32:29 programing the refresh data " the list box that show what data we put in the excel output sheet " @37:37 programing the reset button @38:07 programing the exit button @40:12 programing the search button @46:34 programing the update button @49:55 programming the delete entry button @52:21 programing the list box to show the output @55:55 programing the button to show the form

its a very good form to understand the beviour of VB. Time for understanding it, is vital. Thanks

you are legend brother. easy and straight to the point.

A big thank you from bottom of my heart. Learned and enjoyed the video. Sir.

Excellent video and training style, easy to understand

Excellent work, Sir. Thanks from Sri Lanka.

Thank you for this video. Well explained and it gave me a lot of ideas. You did a great job.

You are indeed a great teacher, the approach used to explain every bit of the video is superb thanks

I wants to express my profound appreciation to this super tutorial. Thank you Sir!

Well done. It helped me to create my data entry form. Thanks

First, thanks for the lesson, it helped me a lot. Second, just a small thing, when you set the variable "lr" (Last Row), you writed "le", it work at the same.

Excellent, Thank you so much.

very nice tutorial.Thank you

Thank you indeed for you generosity and patience in sharing this valuable knowledge, Sir. - From Burma

It's very useful to me thank you so much

The best. All in one

Thanks so much. i feel like a pro now

Thank you very much for your video

Great and Easy

Wow! Great Video

thank you so much. this video helped me a lot.

This was an excellent tutorial.

Informative.

Nice dude and thanks

Great job

Awesome tutorial, crystal clear. You are truly a legend on the subject! With the delete control, the code is a bit longer, why not using the clear method as Me.Clear?? Just thinking louder! Before clearing it would be great to get a confirmation (MsgBox "Are sure you want to clear the record?", vbYesNo), If yes then proceed. At the end, as you run the macro to show the form and it overlaps with the data sheet, again, it would be great to get the data sheet hidden.

sir, In the beginning, you did not state how you created the"MACRO" button to open up the data information form. It also would have been nice if I click to open this project it opens automatically the input form. is it possible to write a short script for the save option?

thank you mi pana!!! for posting

Love your tutorials. Made me a workbook with films and series I have seen. But... When I search for a film/series I need to be exact in searchbar. I need to set uppercase and lowercase depending where I put it in the title. I want to do the search with just lowercase. Is it possible to do that?

Excellent, thank you

Love u lot sir❤❤❤❤❤

nice information and it helped alot. Thank You. When i double click in the listbox the info appears above except the date is a jumbled set if numbers and does not stay in format. How do I fix that?

tqvm...this is very helpful...i have tried and it is working....just one thing, the search function only works when I entered the Emp.ID....other than that, the search function will not work...am I right?let say if I want to search by name...anyway..this video is great

Thank you sir 💯

its great and i wuold be very pleased if i get file.

thank you very much sir

This is great job, thank you very much for the good work. I created my form and is working perfectly, please help me on how to add "Do you want to delete the data" vbYesNo before deleting. I watched many of your videos and I tried the code but it's not working. please help.

Thank you.

Thank you so much

Thankyou so much for brilliant userform. But pls let me know how do I search data from multiple sheets. Regards

Thank you very much for your video, but if you want to add more testboxes to the Userform, is there a way?

Thank you so much! this is amazing! I have a small question, how can you prevent duplications? for example if you want to make sure that all employee IDs are unique, and in case you have entered a duplicated number, a message box appears telling you that and the rest of text boxes are cleared. Please help.

Thank you for your efforts .. I faced a problem with saving data into a new row .. Once I save data, it will go to replace the previous one and so on .. How to solve it?

excellent

Hi, I must say it's very impressive video it helped a lot to create. I have issue after creating everything I shared the excel with multiple people and at a time entry from many people will failing my excel entry data sheet. Please provide any solution for this

Thanks for the great video. How do you trap duplicate employee ID when adding new user ?

Sir, could you please create a video for creating a large and separate VBA form at once? This training provides a large data entry format, but after running it, the full format doesn't show due to the inability to expand the zoom. Could you demonstrate how to zoom in and out to fill the black space?

Nice

Hi Er.Pedia, may you can help on this how can coding for the duplicate value 1 record is already done but when i'm click on the Edit and after edit i will save again then it will capture duplicate value ? can you advice on this ?

I Like this

Tried the code....it's simple and working... It requires modification for warning alert or duplicate data entry.... If you hit save ...it enters infinite entry to the database. Also, search function in the list box not working...

Teşekkürler Türkiye den Selamlar

Thank you for all the tutorials. They are educative. I wish you please help me: I have created a database in excel. And i have also created the userform. The database that i created has sections all in one worksheet. The sections are: (1). staff information, (2). Students information and (3). Parents information. I used the combo box to list the three sections. So, i want to write a vba code to save staff information in the staff section if i select staff, and save students information under the student section if i select students. I wrote this code below, but it's not working properly. Dim sh as worksheets Set sh=Thisworkbook.sheets("sheet name") Dim lr as long lr= sh.cells(rows.count,2).end(xlup). offset (1,0).row for x=5 to 11 Because we only need 7 staff and the empty row starts from 5 to 11. And then i said: If sh.cells(x,2).value=staff then sh.cells(x,2).value=txtname.value So on... For students: For x= 14 to 100 If sh.cells(x,2).value=students then sh.cells(x,2).value=txtname.value And so on When i use this code even though it saves the information under the required section, but the information will occupy the entire section. Please help me out sir. All of what i did here, i learned most from your tutorials. I always download your tutorial.

Super

Welcome Thank you very much Excellent and clear explanation I have a question I hope you can help me. I have a problem that I could not solve. The problem is as follows (duplicate data): I have created a database in VBA. And I worked in it a button to search, a button to save, a button to query, a button to edit, a button to open a file, and a button to exit. The problem is that the data gets duplicated from the edit button. As for the data save button, I used code to not duplicate the data and it worked and no longer accepts any duplicates. The recurrence occurs from the modification button when I query the data of an employee who already exists (i.e. whose data has been previously entered), and I modify his data with the same data of another employee who is also present in the same database. It saves the modification and migrates the data to the sheet or database, the data duplication occurs and this is the problem I'm having. I used the no-repeat code I used for the save button But it didn't work properly Please help me

Sir. It was a well presented video. Thank you. Would u pls advise when I update my data, all check box information was changed from 1 to TRUE. But I want the result is shown in "1" instead of "TRUE". Thanks.

Great job, but how we can filter listbox as we type in a search box, pls if you can help me in the same user form in this video , thank you in advance

Thanks

Great work 👍🌹

This was an excellent tutorial. I was able to create my user form without any issues. Thank you very much! However, what if someone saves the Employee ID twice? You now have multiple lines with different information. How can you prevent this from happening?

Great Tutoring. With the delete function, once the delete has been executed its done. Just wondering if a a message can be created to ask if you are sire you want to delete with a Yes or No BEFORE its deleted ??

Awsome video….how to send search data through outlook kindly advise

Quick questions of adding filters: 1) if someone wants to arrange the excel sheet based on dates or any filter. How to code it ? 2) if we want to add filters in list box for visual how to do that..

Would love to access the file but the link does not provide a location to download to the file.

Thanks for teaching. Can you teach how to create none duplicate ID in this form ?

I would like a video on using Date field in the VBA form?

Very good Tutorial.. just what I need.. BUT, I'd liek the form to update a TABLE, rather than a simple Data array. what changes do I need to do to the Code Simon

👍👍👍☺️☺️☺️

Thanks for your excellent explanation.... Can you help me..specific date wise data entry. If i select 12-08-2023 date but today date is 18-09-2023.. In that time the data will save this specific day. (12-08-2023).

A very informative video. Thanks for this sir. Will you please make a form for sales invoice which is very imported and the fact is that even I am not able to find it in RU-vid for almost 7 months. If you could please make a video for sales Invoice form it will be so kind of you. Thanks

🥰😍

When i convert the range to table, and delete a record with reference no. 1 and add the same record again then it doesnt show in the excel sheet and also it doesnt show in the listbox, but when i apply any advance filter then same data shows up, how to fix it? the data must be shown without applying advance filter every time.

i have a Problem if i press on Save it will save in ecxcel but on the first raw, then wenn i but new data in vba and press on Save it will delet the old won and replaced it with the new won? it will notput automatikli in the new raw now it just replaced the old with the new won. What can i do to chnage this?

Hi, great video. Is there a way to input the data by default as "Unknown" in the fields where there's no data?? Thanks in advance.

Can you add an entry field, so after each new line is entered it counts up. This makes searching for information easier if there are similar dates with different information.

hi I tried your tutorial and everything works except the update part that is wrong, yet I wrote it identical the values ​​do not update, could you have a solution?

very good toturial.. can i get copy

Sir, I tried your form and made an error somewhere, I can only see the Userform in draft mode?????? how do I fix this? would you be able to assist

how come when you click the (32:17) listbox and delete the code, it shows the refresh data? thank you

Your tutorial is awesome. But I have a problem. In combo box of department, if I enter a value which is not available in the drop down list, I need a message that this item does not exist in database or row source and do you want to add it to database. If I say yes and add the item in the database, it should appear in the drop down list. And the message box should disappear and save the data. How can it be done? Thanks for your help.

Wao many thanks did you sharing the download please, the link its break

Awesome video. Anyway I could get a practice sheet?

how do I change the coding for the search function to search data from any field?

the download file link not working

Hello brother, can you put this project in a link so that I can download it?

Dear Sir, Trying to run your "Employee Details Dynamic form" which looks great, however an error showed up. It said: "Error 2147352571 (80020005) Cannot set up the characteristic (reference) ColumnWidths. Type doesn't match" Looking in the code where the Error showed up, this line came up highlighted: .ColumnWidths = "80,140,70,130,100,150,80,80" Hope the can tell why and what to do. Thank you in advance

Sir, Many thanks for uploading such a video. Sir, I am facing problem in the statement as lr=Sheets("Worksheet").Range("A"&Rows.Count).End(x1Up).Row and also I couldn't not catch you how you have brought Regresh() in the code. Please help me by let me know the exact procedure to solve the matter. Thanks once again.

Your tutorial is nice, but I am unable to get Cells option in command With sh and next row .Cells. Please guide me

Sir, please upload a segment of code for preventing duplication of the code while adding a new record to the database. I have another urnest request to you for uploading another segment of code for searching record by entering a partial code i.e. "10.." for "101", "102" "103" & "20.." for "201","202","203" etc. Thanks. Lot's of love & respect to you.

The link don't work

I want a code like this but to color the row that has a condition with a nother color when update data in update command button

Hello. what is the code if i want to search not just in the employee ID? Like for example i didn't knoe the Employee ID but i know the name. Please help thank you

Thanks a lot could you please share file

Hello sir plz tell me how to set color in male or female word in combobox and list box

Hi this is great. Can I please get the latest file that you have for this. Thanks , much appreciated

How to retrieve data without searching. Say, i double click the data from tge listbox - is this possible?

why i click save it not drop the data after column name ? i do as the same yours

I have a problem on the caller. Everytime i call the sub refresh data im having error

Bro i have problem in the delete button. I did just like what you did. But there debugger at Rows(y).Delete.. I dont know how to proceed. I stuck here.. it says run time error '1004' Delete method of range class failed Still No reply after 9 months.. 😢