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