Edit and delete data in a table with a userform

Hi community,

I am in despair.
I have an Excel file with 2 tables called:
1.) Staff
2.) Managers
Headers are ID, First Name, Last Name, Salary.

I have a code to add a new entry to the table and it works fine.
But I just can't figure out how to search, edit and delete an entry.
What I would like to have is, when I enter an ID in TextBox1 it will auto-populate First Name, Last Name and Salary.
If I select any textbox and change the value in it and press Edit, it will update the values in the table also.
I would also like to have a delete entry button, which would delete an entry by searching for the ID.
Any help would be fantastic.
Thank you so much.

I would think...This is all you require...For Now...Your requirement might change...

Please note there is no error code incorporated should you not select Table...etc etc
One button for both edit and add...
Select Table from ComboBox
Enter Id...If it exists it will populate TextBoxes...
Make changes and press button...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

For newly created Delete Button...

Please Login or Register  to view this content.

How about:

Please Login or Register  to view this content.

Edit: Should have refreshed... since Sintek replied while I coded, oops.

Edit: Should have refreshed... since Sintek replied while I coded, oops.

@ Arkadi...Not at all...options...so many options...That's how we learn...

Glad I could help...Tx for rep..PS, I uploaded a new sample incorporating code in case your Table is empty...

Here you go...

Nope...I too am still learning every day...This Forum and its members are great Tutors...Happy Coding...
You will have to incorporate code that clears the Text Boxes after execution...