วีดีโอ

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

My only question is why use a ListBox showing the records instead of just using the form to insert records into the worksheet? Is there something I am missing? Thank you.

Excelente aporte. Muchas gracias.

Thank you very much for the lesson, it's a pity that the example file is no longer available.

Sir, I really don't know how much time you have spent to make this video. But, thank you for your patience and sincere effort. THANKS AGAIN.

The Download file link: fails. Can you fix it? I would love to see the finished product. Thanks!

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

Useless

Hello Er. Pedia Flm a lot of your videos, they are very helpful to learn more of your knowledge. I noticed this video because I made it identical to how you built it, but I encountered a problem: cmbSearchBy does not serve, or is not connected to txtSearch, because without selecting an option in cmbSearchBy, it appears as a search whether by name, phone or address?

The download file link not working because "Unfortunately, you cannot access this item because it violates our Terms of Service." Well, so what? You offers your workbook, but does not give it.

This tutorial was awesome! Thank you so much!!

Really good explanation and great idea, Thanks Man

man i love you!!! i dont know anything about VBA but after all of your explanation i luckly did it on my first report. thank you so much!

Hello Sir Thank you for the nice explanation and nice video. Please tell the code how to avoid duplicate entry of Employee ID. Kind regards Venu

Please Help me, I can Open the file, because it says "We're sorry. You can't access this item because it is in violation of our Terms of Service."

Thank you for this. I would like to know how to add filter for the listbox.

I use the formulas provided in this tutorial and custom design slightly to suite my needs. However I always have a probem when I get to the update fuction as it creates another line and would like to update the information on the same line. Secondly I wish to add multiple pictures to the userform. May you please kindly assist me in that regard.

I use the formulas provided in this tutorial and custom design slightly to suite my needs. However I always have a probem when I get to the update fuction as it creates another line and would like to update the information on the same line. Secondly I wish to add multiple pictures to the userform. May you please kindly assist me in that regard.

I have tried the code, when try the enter data into Excel, only first codeline textbox.value is updating into worksheet while run the code, rest of the values not updated, the execution ends without error, could you help me to resolve this problem

Brilliant work!!

sir when i open developer tab property sheet changes not visible in bottom.

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 the great video. How do you trap duplicate employee ID when adding new user ?

Sir, how to protect the data for the worksheet to avoid delete data my mistake

Excellent, thank you

Thank you so much sir

well

After reset.. username need to show always in userform any code

i am stuck something anybody can help me please

The link don't work

Thank you sir 💯

Good afternonn, I am making your vba calendar. Everything works until the step where I click on a date and my date is supposed to appear in my textbox1 box at 42 minutes and 30 seconds. I don't have any dates written in this box. I am discouraged. For what. Thank you for your help. Audrey

Oh my eyes. My OCD is triggered, please align your combo boxes and distribute them equally, 3 on each side or 6 in a row. Thank you for the knowledge tho!!

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

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.

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?

Dim sh As Worksheet Dim oBook As Object Dim oSheet As Object Set sh = ThisWorkbook.Sheets("Database") Dim le As Long lr = Sheets("Database").Range("A" & Rows.Count).End(xlUp).Row ''''''''''''''Add data in Ecxcel Sheet'''''''''''''' With sh '.Cells(lr + 1, "A").Value = Me.txtfahrzeugtyp.Value .Cells(lr + 1, "B").Value = Me.txtkundenid.Value .Cells(lr + 1, "C").Value = Me.txtdatum.Value .Cells(lr + 1, "D").Value = Me.txtuhrzeit.Value .Cells(lr + 1, "E").Value = Me.comboboxlieferart.Value .Cells(lr + 1, "F").Value = Me.comboboxgroeße.Value .Cells(lr + 1, "G").Value = Me.txtfahrzeugtyp.Value .Cells(lr + 1, "H").Value = Me.txtid.Value .Cells(lr + 1, "I").Value = Me.comboboxfarbe.Value .Cells(lr + 1, "J").Value = Me.txtaufgeb.Value .Cells(lr + 1, "K").Value = Me.txtabholadresse.Value .Cells(lr + 1, "L").Value = Me.comboboxabholort.Value .Cells(lr + 1, "M").Value = Me.comboboxabladeort.Value .Cells(lr + 1, "N").Value = Me.txtlieferadresse.Value .Cells(lr + 1, "O").Value = Me.txtstrecke.Value .Cells(lr + 1, "P").Value = Me.txtzeit.Value .Cells(lr + 1, "Q").Value = Me.txtpreis.Value .Cells(lr + 1, "R").Value = Me.comboboxbezahlung.Value .Cells(lr + 1, "S").Value = Me.txtausgaben.Value .Cells(lr + 1, "T").Value = Me.txtrest.Value .Cells(lr + 1, "U").Value = Me.txtkmstand.Value .Cells(lr + 1, "V").Value = Me.txtendkmstand.Value End With ''''''''clear boxes''''''''''''' Me.txtkundenid.Value = "" Me.txtdatum.Value = "" Me.txtuhrzeit.Value = "" Me.comboboxlieferart.Value = "" Me.comboboxgroeße.Value = "" Me.txtfahrzeugtyp.Value = "" Me.txtid.Value = "" Me.comboboxfarbe.Value = "" Me.txtaufgeb.Value = "" Me.txtabholadresse.Value = "" Me.comboboxabholort.Value = "" Me.comboboxabladeort.Value = "" Me.txtlieferadresse.Value = "" Me.txtstrecke.Value = "" Me.txtid.Value = "" Me.txtpreis.Value = "" Me.comboboxbezahlung.Value = "" Me.txtausgaben.Value = "" Me.txtrest.Value = "" Me.txtkmstand.Value = "" Me.txtendkmstand.Value = "" Me.txtzeit.Value = ""

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?

Very helpful and thank you so much ❤

How can I add a calendar to this vba form, I have tried and cant seem to find a way.

GOOD JOB BRO , YOU SOLVED A BIG PROBLEM FOR ME AFTER WHATCHED YOUR VIDEO

I am unable to delete duplicate frame ? Please suggest

How can i remove or delete frame

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

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

Thank you so much

Hi, lot of people having doubts here... can you please help us

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?

There is no exit uption in user form how it can brings...????