VBA User Form: Add, Update, Delete and Save

In this video, we create an Excel data entry form with UserForm VBA.
You can add, update, delete and save the data.

[stewartwilkinsonsnr]

So I’m a 76 retired male who took up Coding using Excel during COVID, my daughter-in-law saw some of my work and ask if I could design her a Shopping Accounts System. I was so thankful for finding this video as was having trouble with the record numbering when a record was deleted. I sat with a cuppa and watch and to my excitement saw your approach to design and coding was just what I needed. So my Sincere Thanks for saving me time trying to solve. For me this is why YouTube can be so helpful. Thanks again 👍👏 Stewart UK 🇬🇧

[Me_ThatsWho]

I have to admit, this is the BEST video of its kind (believe me, I've viewed a ton of them). I learned a ton in a very short period. The solution is quite polished and professional. It almost makes me want to skip using my database (almost!).
Btw, a tiny suggestion- perhaps a better electronic voice. Otherwise, perfect tutorial.

[TheGuggo]

Very professionally made and useful.
Some suggestions: name the command buttons with their action instead than with a number. When going through the code is much easier to navigate.

[POMI_Singing_Guru]

YOU ARE THE SUPERB I LEART ALOT AND YOU HAVE AMAZING STYLE OF TEACHING

[lstevens]

This actually works great. Very professionally done. I was able to relabel it and add more columns to match my spreadsheet at work and was successful.

[Belive_in_Jezus_Christ]

Wonderful video! I saw that I did it the way you did, and it turned out the same. Thank you so much Hay Kel!

[BPSJV]

Hi. Thanks for the video. It's very helpful. I have a doubt. I'm using the same in AutoCAD VBA where I'm not using excel to save data. Instead saving it to array variable. I pop up autocad using command button and some operations are performed then userform is showed again. The data is not appearing in list box but is available in the stored variable. How to show the existing data in the list box. please help.

[ProGamer-ynvh]

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?

[neelslombard]

I have a second question, how do I add unique ID codes? instead of the normal 1, 2, 3, 4.... I would like to add a ID that reads AP-1, AP-2 and so on. What would I have to add or change in the existing code?

[shijinchen]

Why i can only update one data (new data inputed in all the textbox)?

[redskinsfan]

Can you get the option selected on an option button added when double clicking the list box line that you want displayed?

[WeltonMadureira]

Can I make a dynamic search at the same VBA User form??

[IzzyUsi]

Can it be saved as "macro enabled"'? if not, please clarify

[karimmimoun]

Thanks for the video, hopefully you can help me have a question I also use an ID number linked to the cell this is automatically generated for every new entry on the first sheet . When the ID is processed it is also automatically moved to the second sheet of the (closed ID) the problem is when it is moved I get the same ID number again on my first sheet do you know how I can keep this number unique? Do you have a video of this how I can keep it unique? Thanks in advance

[tropicaland]

Great work. I was waiting for such a video like this.thanks a lot

[ahmedJaber]

I love it
Exactly what i need. Wonder if u could share the file/code

[Grendel-mqji]

i did exactly in the video but error in delete function, "delete method of range class failed"

[videoclubmultimedianiel]

Hello, with the update it update a line lower than indicated. Make update in line 4 and the update changed line 5, whij Greetings and thanks for this video

[neelslombard]

Great video on coding in VBA. I just have one slight problem and I'm not sure where I went wrong, as I copied each step as the video went along. My workbook is setup slightly different as to what is used in the video, but same principal. My issue is when I add my data to the spreadsheet, it starts at A3 with ID code 2. I tried completing row 2 manually by adding ID 1 in A2 and filling in the rest of row 2. But as soon as I add new data through the Userform, it skips one row(A4) and enters all the data in A5 with ID code 4. I ran through my coding several times to make sure everything matches what the tutorial explained, but yet it keeps skipping that one line. I tried doing a update on the skipped line, but as soon as new data is loaded it skips the last row. Please help, I do not want to do this all over again.

[ahmedelwaraky]

this video help me a lot so thank u my friend, go ahead