Edit and delete data from database using userform in excel

rajesh.shishodia Posts 1 Registration date Monday September 21, 2015 Status Member Last seen September 22, 2015 - Sep 22, 2015 at 12:19 AM
Hi Team,

Need some help!

I have been working on a userform for entering in and editing data in a database sheet which is located in my share drive folder (Z:\Export data.xlsx).In userform Sheet(MIS)
two tabs- client addition and exception client working fine but I'm stuck with the code for deletion and edition data.What i need when i enter client ID in client id text box
all information should display in the text boxes and I expect the changes made in those textboxes will overwrite the existing initially entered information in the database sheet.
and for deletion if would select client id the information should move to sheet2 of database sheet which is located on my share drive.