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

Namaste everyone. Thanks for your love and support.

In this video we will learn to make employee details dynamic form using Excel VBA.
Queries solved
1) userform add button
2) userform reset button
3) userform exit button
4) userform search button
5) userform update button
6) userform delete button

Download file link:

If you need any help, you can DM on my Instagram

#erpedia #excelvba #userform #step_by_step_tutorial

[pabblizard]

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

[hassanfornah]

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

[georgekhaba]

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

[WaresHadi]

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

[asadreet]

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

[ottahdynasty]

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

[CarlosCerqueira]

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.

[salemkraidi]

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

[subedy]

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

[osoriomatucurane]

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.

[JanBolhuis]

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

[ajitSk-gv]

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

[dennisdnarmu]

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.

[thill]

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 ??

[catherinegrundy]

Thank you for your very clear and helpful tutorial. You have taken my project to the next level :)

Currently the list box displays all data entries at all times, which is ok as a general display for users to scroll through, but on searching for a record using ID number I would like the list box to only display the rows and columns of data that match the ID in the search box.

Most of the time an ID will be unique to 1 row of data but occasionally there will be 2 or 3, so this would also function as a way for users to find, edit and/or delete the correct record by double clicking on the entry in the list box.

Please would it be possible to confirm what I would need to add to the code to only display matched search criteria in the list box?

Many thanks for your kind help,
Cat

[seshakv]

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

[sawkyawhtike]

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

[koshomori]

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.

[KEVINTVFACTS]

wow nice tutorials, can send another link to download the script thank verymuch high appreciated

[solomonmuhabaw]

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?