Code to edit data in data base

[KIM Chanthan]

Hi,

Anyone know how to edit data in database?
Let say, I have 2 sheets, 1 is for input information then i will transfer it into sheet database (I already know how to do it). But I don't know how to do when i want to edit some info in database sheet. For example: I want to change age, gender....which is already transferred to database sheet.
My question is i want to create another script to edit by just input Code in cell B2 and all info like name, sex, age will be appear following what is store in database. Then when i change those name, sex, age it will be edited in database too.
I would be appreciated if you can send me the related lesson of this problem as i am very basic of VBA.

Thanks,

 

[dan_l]

This will be vastly easier if you do this with a VBA form.

 

[Belleke]

Is this what you are looking for?
See attached

 

[KIM Chanthan]

Is this what you are looking for?
See attached

Dear Belleke,

It's very nice!!! It would be appreciated if you can send me some link of the lessons related to this trick.

Thanks again

 

[Marc L]

Hi !

From Excel inner Macro recorder, just try this :​

Sub Macro1()
    Worksheets("Data base").ShowDataForm
End Sub

Do you like it ? So thanks to click on bottom right Like !
​