Fully Automated Data Entry User Form in Excel - Part 2 (Edit and Delete Records)

[@thedatalabs]

Please watch the Complete Tutorials (Part 1, 2, 3,4 and 5) of creating Fully Automated Data Entry Form in Excel. Part 1 (UI Design, Transfer and Reset) - kzbin.info/www/bejne/hmaWhWmlrcyIjKM Part 2 (Edit and Delete) - kzbin.info/www/bejne/gWLHZX2mqrGep6c Part 3 (Search and Filter) - kzbin.info/www/bejne/eJWofp1qg7OLd6c Part 4 (Validate and Print) -kzbin.info/www/bejne/ZpOpgH6mlrh8eMk Part 5 (Full Screen, Zoom and Dynamic Drop-down) - kzbin.info/www/bejne/nGi6ZHuIgbaMd9U

[@sri9382]

TheDataLabs bro I need your mobile no.

[@thedatalabs]

Please send me mail.

[@idle-idiotslabentertainmen7189]

Thanks for the links. Can you help me with this. How to google search from multiple cells in excel. Need a VBA code for this.

[@ThomasGrant]

Will you be doing a part 6?

[@thedatalabs]

Please suggest the features. I will definitely create if that will be easily incorporated in current form without any major modification in structure and code. Thanks!

[@SquireDAF]

I have wanted to try this type of things to help my work out for a few years, always wanted to learn some coding but get scared off or overwhelmed, yesterday tried another youtube guide but i was messing it up or misunderstanding the guy, many cups of tea and about 10 hours later gave in then saw this video and started and not trying hard and couple hours later its pretty much good to go to start with, thank you very much you are a lifesaver!!! I cant find it yet but for some odd reason it skips 2 rows on the spreadsheet when first entry goes in so starts at row 3, then its ok will hopefully find it but untill then i am a happy man

[@PatMcMorran]

This was a lifesaver. You just saved me several hours of work on a friday

[@thedatalabs]

Thanks for your feedback!

[@familiapipajose2196]

Man, you have no idea how many manhours you saved from my day to day at work with this tutorial. Thanks so much

[@thedatalabs]

Glad to know that you found this tutorial helpful. Thanks!

[@omv6076]

Best tutorial from TheDataLabs with right pace and clear explanation on VBA codes. Thank you very much Dilip...Great job!

[@HolyQuran0992]

Thank you very much for amazing tutorial. I've a question regarding video time stamp 20:49 When someone want to delete the 2nd record not the 3rd so why the Sr.No is not changing according to the Entry. When I deleted the 2nd record the Sr.No 3 is not changed to 2nd. Please help me out need quick. Thank you

[@Mmmmmmmeowth]

Thank you so much! This series has helped me a lot!

[@zishxing1036]

Excellent video. Thanks.

[@omv6076]

Hi DataLabs can you incorporate an "EXIT" function to this Data Entry form? Once the user click "Exit" you get a message "Do you want to save any changes?" if Yes, then it will Save then Close the Excel. Just thought it would be nice addition? So far you guys did a great job. Thanks

[@idle-idiotslabentertainmen7189]

You are doing a great job. Add videos where we can learn complete basics of VBA

[@thedatalabs]

Thanks for your feedback! Will try to do.

[@mohammedfareed9916]

Thank you so much. I learned a lot by this video. With zero error😊

[@nabilaltalebi9757]

Very simple and useful ... thanks a lot

[@ajulie7878]

That is GREAT. Thank you very much!!! One thing I would have like to know is what would be the code for the Edit button when you have a check box... Very unexperienced with VBA... Again, thank you - users will love this!

[@ramisignals2720]

You are superman i like your videos to much Thanks A lot keep same

[@osamasaid8476]

you are great teacher

[@rvjordan2981]

Good Day i realy love the method its very clear but as a it student before i'd notice some little miscalculation like in this video it can't delete the 1st data that we have and also regarding with date in its different from the first setting that shows just that thanks a lot no hate .

[@carlgrigg]

Thank you for the tutorials, I have completed the first two and have managed to write the database I need along the way, when getting towards the end of number two I thought "I need a sort or search function now", just noticed the subject for part 3 so I know what I will be doing tomorrow :) thanks again.

[@samcbk]

Great tutorial... very well explained!

[@thedatalabs]

Glad you liked it

[@abdelhalimachlouj5793]

Thank you so much man. An amazing tutorial witch helped me a lot to understand the concept. Keep it up and looking forward to your next videos ...

[@abdul-rahman-mahdi]

Perfect work, Thanks for sharing your knowledge. I enjoyed watching.

[@michaelnakakubo6791]

Great help! Fixed my code with your video. Thanks!

[@zahidmq3504]

Great tutorial!!!

[@ashimkarjee]

Kindly make a similar video on how to search for specific data using credentials saved in the main database

[@cicerolobo7583]

Excelente aula. Parabéns. Obrigado por postar essas aulas. Deus abençoe.

[@lawriescott9415]

Thanks for this tutorial, really simple to follow and very useful code. I did notice one problem and that is if I delete a row somwhere in the middle then add in a new record the Serial Number can end up duplicated. I wrote some code to work around this but just for future reference maybe consider updating that in your code.

[@JWillB1]

Hey Lawrie Scott, I’ve got the same problem how did you work around this? Would be very helpful. I’m still learning. Kind regards.

[@lawriescott9415]

@@JWillB1 Hi I have a sub routine for submit. The line .Cells(iRow, 1) = "=Row()-1" 'Dynamic Serial number sorts this out Sub Submit() Dim xSht As Worksheet Dim iRow As Long Set xSht = ThisWorkbook.Sheets("Database") If frmForm.txtRowNumber = "" Then iRow = WorksheetFunction.CountA(Range("Database!A:A")) + 1 Else iRow = frmForm.txtRowNumber.Value End If With xSht .Cells(iRow, 1) = "=Row()-1" 'Dynamic Serial number .Cells(iRow, 2) = frmForm.txtID.Value .Cells(iRow, 3) = frmForm.txtName.Value .Cells(iRow, 4) = IIf(frmForm.optFemale.Value = True, "Female", "Male") 'Research IIF ?? .Cells(iRow, 5) = frmForm.cmbDepartment.Value .Cells(iRow, 6) = frmForm.txtCity.Value .Cells(iRow, 7) = frmForm.txtCountry.Value .Cells(iRow, 8) = Application.UserName .Cells(iRow, 9) = [Text(Now(), "DD-MM-YYY HH:MM:SS")] End With End Sub

[@JWillB1]

@@lawriescott9415 thank you I will try this tomorrow 😀, I have some other issues as well maybe this will solve that to. Have a nice day.

[@Arifkhan786]

Dilip Kumar you are amazing thanks for the great videos I have subscribed and watch every video Thanks 🙏

[@thedatalabs]

Thanks for your kind words! 🙏

[@walterbobrowski4761]

Absolutely beautiful coding and form design! Thank you for sharing this and your easy to follow instructions. I'm still trying to modify some textbox controls to autofill using a LOOKUP function to retrieve CITY and STATE, from my ZIPCODES worksheet, once I enter the zipcode into my zipcode txtbox control. Many online solutions are available, but none of them work properly, and error messages don't mean anything to me as I am not well versed in VBA. I don't fully understand why VLookup works easily in a speadsheet cell, but not in a form control. (but I can follow along and understand, and modify). I'll keep working on it.

[@AbhishekMishra-cr1tz]

Very nice and useful video

[@thedatalabs]

Thanks for your appreciation!

[@raidalkhalaf4518]

thank you very much for part 2

[@venkatesanbalakrishnan2460]

Thank you very much. How to auto calculate values in some of the fields?

[@amyroamyro8344]

you are the best!!!

[@jbosler58]

Hi I love the help videos they are wonderful and easy to follow. I have a question! What if I don't want to actually delete the record but want to move it over to another sheet. It will be moved from the original sheet to another sheet to store the data so it is not lost.

[@jomelreyes9133]

Thanks I love the Content Keep it up

[@santosozhang1985]

Thank You very much for the lesson. Excellent!!!

[@juonariobaterzal6063]

Great big help!!! Thank you!!!

[@thedatalabs]

Thanks for your feedback!

[@wasifabbas8160]

First of all, its really good stuff which clear and is user friendly. I have one query that what is ME, which is using in the edit command button in video at 13:15 min. Kindly address this query.

[@thomasgiovannigiangan4650]

Hope you have a tutorial to prevent duplicate entries for the emp. ID.

[@shmaitlo]

Hello its a wonderful by watching your video , i would like to ask how we can mention date formula ?

[@mariantonys]

super Mr. Dilip

[@thedatalabs]

Thanks for your feedback!

[@aimendondo]

Great work!!!

[@orucreis3219]

Süper 💯💯💯💯

[@narasimmanraoappanna5640]

Thank you very much on your tutorial s. Could you please help on this question below. How to make a data entry into password protected excel via VBA?

[@tropdropper]

Thank you for the tutorial its really helpfull i have only one question: when i delete a row in the middle of the database, and after that i add a new order. The S.No repeats the last S.No in the database

[@thedatalabs]

Thanks for your feedback! I have covered the dynamic serial number in next part of this tutorial. Please watch complete series for all additional features. Thanks!

[@ВиленДаутов]

Отличная работа! Высший уровень! Спасибо большое. Хотел узнать про изменение списка через listbox можно или нет. Теперь вижу что можно! 👏👍👍👍

[@myhome138]

Thank You very much

[@prakashlamichhane738]

First of all, a huge thanks for your tutorial it is very friendly to understand. I have a question below. Is it possible to flash more forms to fill multiple sheets of data. For example I want to make automated form and database for 10 pages of data like basic info, educations, professional career etc. for that I want 3 forms to flash and stored in different sheets below. If yes I will be happy to learn.

[@joshuataruc3722]

Very helpful video. Is there any way to lock a certain cell so that it couldn't be changed after the data has been entered?

[@melchizedekmends357]

Hello Dear, you are doing a superb work, kindly add another option "filter" to this video and also indicate how it can be applied to data query. Thank you

[@thedatalabs]

Thanks for your appreciation! I will upload the 3rd part with Filter very soon. Please keep watching. Thanks!

[@melchizedekmends357]

@@thedatalabs I would like to contact you. can you please give me your email address.

[@suvaisaran]

Hi very nice to explanation i can try to make a simple fm but its shows below error Run time error 13 Type mismatch

[@rissaivyhaireewee6759]

i got this too

[@thedatalabs]

Can you share the line of code where an error is showing? Thanks!

[@socheathyem482]

Your work is very helpful for dialy work. But it seem to be editable for less than 10 columns. If i want to work on more than 10 column how to do?

[@grahamparker7729]

Nice 👌🏻

[@hiveworld9983]

AWESOME work bro. Thanks for helping us to aware awesome methods in beautiful way. I make this format but when I click launch form it show "could not set the RowSources property. Invalid property value". Will you pls tell me how I fix it

[@thedatalabs]

Thanks for your feedback! Please share the line of code where error is showing.

[@yasar99444]

thanks you bro

[@yahoomail6422]

THANK YOU BROTHER

[@anjalinairu7346]

Thanku

[@faltuwaste]

No doubt tutorial is up to mark, but every one can't do due to lack of knowledge regarding vba programming

[@lakkthari4969]

Hi This is a Great Tutorial... Could you please give the code to update the values to respective controls in a CHECKBOX... In the Edit button Section

[@marieflores1540]

Thank you for this tutorial. Ive been following all the codes but when i run the program, i got this error when i click Edit it says "Could not get the list property. Invalid argument." Hope you can help me with this. Thanks!

[@typicalmotuan838]

In getting the same error also

[@vetu3573]

Got the same error with deleting

[@arvinthramakrishnan6233]

Is it possible to create a function that create a new excel sheet with the data we input. I.e adding a "create workbook" button on the data form ? when we click, creates a new wb using the data we input.

[@ricardaskr]

Thank you :) Nice video.

[@ilykgurl]

gooday. its possible to change delete command as move? so that i have backup/history for what i delete? i think if can make other sheets for delete info. thank you

[@alvingapay2592]

Hi Mr. Dilip. Can you make a part 6 of this? Can we make a lookup button to search and update data? Thanks and more video please.

[@thedatalabs]

Thanks for your suggestions! Will create a new tutorial as adding code in existing will create confusion.

[@alvingapay2592]

@@thedatalabs thank you Mr. Dilip

[@bhaktichanneltemples3287]

Super sir

[@jktthant8304]

Thanks

[@rameswarreddy6336]

Hello Sir, you are doing wonderful job! I have a couple of questions. What could be the reason that my S. No does not update when I delete a recodr? Ex.) I delete the 3rd entry so the 4th should then become 3rd however, it remains as 4th. Thank you

[@thedatalabs]

Thanks for your feedback! Please watch the other part of this tutorial. Have covered this. Thanks!

[@lubumbebrian4336]

This is the challenge I'm facing as well..,

[@oladelejohnson1390]

very good - thank you - one error I keep getting is the user form gets stuck on my cmbProcess record - what could be the problem…?

[@johng5295]

Thanks in a million. Great content. Awesome imagination. ❤️I subscribe❤️. Grade: A++💥

[@mikeegharevba2741]

Hello, I like your work, can I get an already existing app that I can be using to update and modify employees data?

[@nicktobies]

wonderful teachings...you are good

[@thedatalabs]

Thanks for your feedback!

[@WorldSolutiontv]

Thanks for this video, please can i take a link to download the file ?

[@fedo_figo95]

Well thank you for your great effort your videos were really helpful. But I'm wondering if I'm selecting a row from the list without clicking on edit and I entered new data ,will it will overwrite the original row (deleting existing row and adding the new row data)

[@thedatalabs]

Thanks for your feedback! Without clicking it's not possible. Please check the code again and let me know if it's happening. I will go through the code and make the correction, if required. Thanks!

[@fedo_figo95]

First thank you for your interest and reply, I just wanted to assure I'm understanding it, So if we selected any row from lstDatabase the txtRowNumber.value will change or not if it will change then when we call sub submit the [iRow = frmFirm.txtRowNumber.Value] will enter the data on that selected row. I'm so sorry if I'm asking maybe not very smart questions but I'm new with this and I just like to understand more.

[@thedatalabs]

Most welcome. It's good question. Once you click on Edit then it will assign the respective row number to txtRowNumber so that while submitting data, code will use the row not the blank one. Once, edited data will be transferred or you click on reset then txtRowNumber will be blank hence, while submitting a new record it will always save to next blank row available in Database sheet. Hope, it clarify your doubts. Thanks!

[@namreshchor]

thank u for this video we learn how to edit and delete can you please make one more video with search option it will be very great full

[@thedatalabs]

Thanks for your feedback! Have uploaded 5 parts of this tutorial covering all features. Please watch. Thanks!

[@dallasgoodall1913]

Hi, I have been following your videos and they are very helpful so thankyou for that. I am just seeking your advise on the delete button. Instead of deleting the record can the record be moved to another sheet for historical records?

[@andrescordero9598]

Geat content! But I was wondering how do you quit the selection after editing any data row? Because when I edit, I can’t return to save data normally, unless I delete a row or something like that

[@CHARANSINGH-lk5wb]

Hello sir , can you please add two more txt box for date and time entry , please extend this series

[@thedatalabs]

Hi Charan, this form is almost full with controls. Please share the details which you are looking for. I will try to support you here. Thanks!

[@jamespyle6398]

Possible to pull up the record by double click it in the listbox instead of clicking edit?

[@katodenis8089]

Thank you for the turtotial. How do you manage to open automated data entry form at same time database opens.

[@ThomasGrant]

Great video series. Up to part 3. Some questions. Lets say I have $100 in cell 3 and 1.3% in cell 4 how do I multiply them in VBA? and then have the result in a txt box? How do I format the cell to show %? the format I tried didn't work very well. Kept formatting it as 131% How do I do Sum total? dynamic I guess. So that anytime I enter in a figure into the database it updates the sum total. Is there a on close window function? So it does something before it closes. In the lstDatabase how do I format the way it displays the info? Is there a way to format how each cell is displayed in the lstDatabase?

[@anaspeermd]

Hi your videos and explanations are great. I want to do the same thing, but without list database. I have created for save and reset. Now I want to create edit with which if I select particular cell in database, I want to load edit function in user form and update values Please help me

[@madhurimotamarri2910]

Hello , I was making a modified version of this by following this I was wondering if you can enter dates in hte text box field

[@sandzstudio]

Hi is it possible you make a video when you inserted the name the age will automatically be inserted in text box too? Thanks

[@thedatalabs]

Yes, we can lookup value from table. We need DOB for that.

[@sandzstudio]

@@thedatalabs thank you, looking forward to it

[@sandzstudio]

@@thedatalabs actually what i am working now is for my store. Like if i inserted a product the price will automatically show up in the other box. Hope you can make a sample for this?

[@johnmichaelparecto5167]

Hi Thedatalabs. I really like this process of automation . But !1question. when I deleted the record, the S number wont automatically change. Like I deleted 2, the order is 1 345 it did not change to 1234

[@raymondryanmeneses3001]

Question my idol. Hoping that this will get your attention so I will be able tosolve my problem. In EDIT mode, what script that will allow the EDIT button to activate only if the date is today. If date is from yesterday , user will not be able to do the edit anymore.

[@HolyQuran0992]

Really amazing. Thank you

[@eakkaphop1214]

Thank you and this help me a lot, but i try to follow Step-By-Step Part 2. I have some problem for "Edit" that OptMale vs. OptFemale cannot change after edit. Can you suggest me more? Thank you in advance.

[@SayaliJoshi-g4o]

Hello, from where I will get the textrownumber which is used in Sub submit(), With my property I am not getting this method Can you suggest?

[@motitsoedanielmafale6305]

Hi. I will like to know how do I save my form so that I can be able to access it the next day I want to use it...or even adding some other buttons because I did the first one and when trying to go back to it I then get challenges whereby I was unable to open it again

[@wqip340]

basically, is there a way to get a list box data from particular sheets?

[@altronick]

Thanks for the tutorial, very helpful!!!! To fix the problem of the incremental number in the first column of the table when Delete button is pressed i wrote this code in the cmdDelete_Click() ... ThisWorkbook.Sheets("Database").Rows(Selected_List + 1).Delete 'added code below to force the numbers in the first column of the table when one row is deleted Dim iRow As Long iRow = [Counta(Database!A:A)] ii = 0 For ii = 2 To iRow ThisWorkbook.Sheets("Database").Cells(ii, 1) = ii - 1 Next ii ' Finish the code related to force the increment number in the first column of the table Call Reset ... Do you have any suggestions? Looks working but probably is not the proper way to code it Thanks again

[@vetu3573]

Hi did you by an case get it right i have the same issue here

[@vetu3573]

My problem 👇 Hi, hope I find you well. I followed your videos till part two and am hoping to continue with them as I am busy with a project. So far so good. Only problem is when comes to deleting after coding. I keep getting "Run-time error '438': Object doesn't supoort this property or method Please help me. Where did I get wrong. I tried deleting the object and then I it says item deleted but records are still there. Thanks for your time to respond.

[@thedatalabs]

Please share the line of code where you are getting error. Thanks!

[@bazookajoez1449]

Can we keep some data on the entry form after we save? For example in your form let’s say city and country would be something common so after u save the data it keeps what u have previously entered so you don’t need to type it again in your next entry?

[@rjrachujeshu]

At 21:07, deleting data. What if we delete second number? Does it reset serial number and becomes 3rd row as second with serial number 2 from 3?

[@akio6505]

Great! Also looking for a employee name dropdown, they select their name then only the cells assigned to that employee will be updated. Is that possible?

[@johnnyadkins9312]

When selecting delete, how do I delete that range and not the whole row? Thanks…Ja

[@abduselamhassen5829]

It is greate

[@princeikechukwunnadi8061]

Hi Great work you've got over here. Please, I am an ICT volunteering in a Junior High School Academy. I want to use this technique to deploy an admission form while I'd make use of wordpress for the web. My question is how can I deploy this form on a website or online for inline registration? Thank you.

[@cloudprojects3928]

Can you share the code of how I can prevent duplication of entry? Is there a call command as well?

[@bdmdcluster-bmisamisorient8619]

Hello DataLabs. First of all I want to express my heartfelt gratitude for many things I've learned from you guys. Now, I am ready to deploy the application to my workmates in the field. I am done with my project though I don't know how to package it and make it executable to other workbooks or computers. Can I ask for assistance with this coming from you guys? Please....

[@thedatalabs]

Thanks for your appreciation! Please post your questions in comment section. We will try to reply with possible solutions. Thanks!

[@chetanthadeshwar9632]

will you do it as per my requirement professionally ?

[@shibilsnoopy3973]

Amazing

[@shibilsnoopy3973]

Can i get your number

[@mdkhaireeroosly3173]

Thank you for the tutorial for the VBA part 1 and part 2. i have been following your tutorial for the past week and i have been doing my own automated data entry form by your tutorial. i am stuck at my data entry form. i have try to find the missing link in my VBA code. can anybody or TheDataLab help me? Thank you in advance.