• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Code to edit data in data base

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,
 

Attachments

  • Edit Database data.xlsx
    8.7 KB · Views: 6
Hi !

From Excel inner Macro recorder, just try this :​
Code:
Sub Macro1()
    Worksheets("Data base").ShowDataForm
End Sub
Do you like it ? So thanks to click on bottom right Like !
 
Back
Top