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.
@hay_kel
4 ай бұрын
Thanks for the comment and for watching! 😊
@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.
@seymourtompkins
Ай бұрын
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.
@hay_kel
9 күн бұрын
Wow, thank you!
@POMI_Singing_Guru
4 ай бұрын
EXCELLENT,,,,,,,,,,,,,,,, YOU ARE THE SUPERB MENTOR.......... I LEART ALOT AND YOU HAVE AMAZING STYLE OF TEACHING
@hay_kel
4 ай бұрын
Thanks for the comment and for watching! 😊
@tropicaland3040
14 күн бұрын
Great work. I was waiting for such a video like this.thanks a lot
@hay_kel
9 күн бұрын
Most welcome 😊
@commoditycontrolserviceslt6655
3 ай бұрын
Excellent Job
@jacksetiyono6179
2 ай бұрын
thanxs bro...
@ahmedelwaraky5
5 ай бұрын
this video help me a lot so thank u my friend , go ahead
@hay_kel
5 ай бұрын
Thanks for the comment and for watching! 😊
@ardisonardiente3066
Күн бұрын
Hi! just saw your vid and it helped me a lot. I just have one problem. there are duplicate entries in my form and when I tried to update the latest duplicate entry, the previous entry was the one updating. I don't know the code to fix it.
@redskinsfan4467
6 күн бұрын
Can you get the option selected on an option button added when double clicking the list box line that you want displayed?
@neelslombard4233
3 ай бұрын
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?
@faizalmarjudi7144
22 күн бұрын
Hi there, great video and easy to follow. I have a question, how can we add data from the top row, meaning the latest data entry will be in the 1st row while the old data will go down. I would really appreciate if you can assist me. Thanks
@ProGamer-yn8vh
3 ай бұрын
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?
@WeltonMadureira
2 ай бұрын
Can I make a dynamic search at the same VBA User form??
@deltagalilvietnam
3 ай бұрын
thank you so much really great..... if i want the latest ID added always on top , how can i do that?
@neelslombard4233
3 ай бұрын
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.
@GerhardtKruger
3 ай бұрын
HI get this error in yellow when vba tested sh.Range("A" & selected_row).EntireRow.Delete please advise
@Grendel-mq2ji
Ай бұрын
i did exactly in the video but error in delete function, "delete method of range class failed" ??????
@WeltonMadureira
2 ай бұрын
I Tried to add another ComboBox at this User Form but I can't make it work, can you help me?
@nellylee1952
Ай бұрын
very good
@hay_kel
9 күн бұрын
Thank you! Cheers!
@jacksetiyono6179
2 ай бұрын
man am try to Add serch box for this but not work man.. can u making tutorial for next video..?
@houssamel_hassani9779
4 ай бұрын
I have an execution error -2147352571 with ( .ColumnWidths = "30,40,100,110,70,90" ), solution ?
@kiko1502592
3 ай бұрын
Same here
@samnangsuonsokunth8719
4 ай бұрын
sir if delete the row the serial number auto update or not sir
Пікірлер: 35