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

its been 2 days that I cant figure out how i got messed up, if anyone is willing to help, please do :D

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

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

Hello from where I can get ur previous videos

Hello sir
Why I can't run Delete function ? please advice.

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

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

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.

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.

IT SAYS NO ROW SELECTED EVEN IF I SELECTED AN ENTRY

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

sir..i already follow the formula, on example u’re delete row number 3, its run normally, but if u’ re delete row number 2, the row number is not correct..row number is not sequentially..hope u can fix it..

Hi, I really appreciates your guidance and your tutorial for data entry form. I am not well versed on this matter but I still managed to figure out what the VBA instructions as I have followed your guidance thoroughly, but I can't figure out what went wrong. For the Delete function, I couldn't delete the record. A pop error message appeared as "Object Required". And when I clicked on Debug. It highlighted ThisWoorkbook.Sheets("DATABASE").Rows(Selected_List + 1).Delete

How do I troubleshoot this?

Anyone can help..why after i edit the old data..its not renew the old one..instead it record as new data..how to fix this??

Too much add

Too much ads

if i delete the midium liste the numbers are not 1 2 3 ... it was 1 3

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?

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

When I click the edit button the information populates into the wrong cells, everything is off by one cell. The error message I receive is, "Could not get List Property" Any ideas what would cause that?

sir i want to code - In VBA User form i want to upload pdf file and save the decided folder with his name and when search to this file in lst database , when double click on it the attached PDF file is open in vba excel user form for a view mode

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

Popcom 🎉❤❤❤❤❤❤❤❤❤😊❤😊😊😊🎉😂😂😂🎉

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

done my second tutorial

you are the best!!!

I have followed your Guidance till Part 2, till Part 1 I was successful however after adding Code of Part 2, I m getting Error in Submit() Block at .Cells(iRow, 8) = Applicatio.userName Line ................................Also while Delete any Data Line it Delets Heading Line .................Please Help

What is dim sGender as string meaning

Great tutorial... very well explained!

Hello Sir i have problem with the coding i follow your instruction and in my code have problem/error here is the error how to fix this problem "run-time error '-214700024809 (80070057)': could not get the list property. invalid argument... i cannot seem find the solution or code that have mistake .. .want solution would you advise or suggest?

Mr Dilip, I have followed your tutorial for deleting code. But, the error prompted out as run time error object doesn't support this property

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

THANKS

Hello,
your tutorial is very interesting and helpful - Thank You.

I have a question about this part of code:


Dim sh As Worksheet
Dim iRow As Long

Set sh = ThisWorkbook.Sheets("Database")
If frmForm.txtRowNumber.Value = "" Then
iRow = [Counta(Database!A:A)] + 1
Else
iRow = frmForm.txtRowNumber.Value
End If


i got the function "Edit" position, but when i change the code to this :


If frmForm.txtRowNumber.Value = "" Then
Else
iRow = frmForm.txtRowNumber.Value
End If
iRow = [Counta(Database!A:A)] + 1

Then i've got the function DUPLICATE

How to conecting this two codes, to get two independent functions: EDIT & DUPLICATE? I've got two button already.
Than you in advance.

I have followed your video exactly and re checked what I have typed, Everything works great except the search, I keep getting this error. Method Range of Object - worksheet failed error code 1004
The following is my code that I typed, can you help?

'Apply filter on Database worksheet

If frmForm.cmbSearchColumn.Value = "Employee ID" Then

shDatabase.Range("A1:I" & iDatabaseRow).AutoFilter Field:=iColumn, Criteria1:=sValue

Else
shDatabase.Range("A1:I" & iDatabaseRow).AutoFilter Field:=iColumn, Criteria1:="*" & sValue & "*"

End If

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?

Hi this is awesome tutorials. i try to follow up your step until edit button. i have an error on this part "Could not get the list property. Invalid argument."

1. need you advise how to fix it?

2. what is "Me" in below command?
Me.xxx.Value = Selected_List + 1
Me.xxx.Value = Me.lstDatabase.List(Me.lstDatabase.ListIndex, 1)

Thank you for you anwser

Search not working for numeric value. Please help!

super Mr. Dilip

how to save the vba code?

Sidr ka form ata nhi hi

Great big help!!! Thank you!!!

but when you delete for example the data in (Serial No.) S No. 5, the the succeeding number which is number 6 will go up but it will not update to become number 5, why is this?

Brother I got error in this problem can u Plss correct it

How can we lock the sheets? It’s still editable

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!

Sir How can show my data as a date format in text box?

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

Great work. Thanks for sharing.