Making a custom search & edit button

[Joek88]

So I have an example of what I want to do. I belive it can be done but would like to get our thoughts on how to achieve it. So I have a list of information that will be pretty extensive including the following: ID's, Names, and Account Balances per the sheet below. I want to be able to quickly search an "ID" in the search box I have created and once the criteria is matched in the search button it will populate the little box below the search box with the current information. Now since this will be a very long list of ID's, I want to be able to edit the "act. bal." tab, press enter, and it will automatically switch the information in column D to the new info. Can this be done? Please see the photo clip for a better explanation.

 

[Bosquedeguate]

So I have an example of what I want to do. I belive it can be done but would like to get our thoughts on how to achieve it. So I have a list of information that will be pretty extensive including the following: ID's, Names, and Account Balances per the sheet below. I want to be able to quickly search an "ID" in the search box I have created and once the criteria is matched in the search button it will populate the little box below the search box with the current information. Now since this will be a very long list of ID's, I want to be able to edit the "act. bal." tab, press enter, and it will automatically switch the information in column D to the new info. Can this be done? Please see the photo clip for a better explanation.

View attachment 97375

have you considered a small form with the 5 controls? (Search button (may not be needed), TextBox for the search value, Labels (or disabled TextBoxes) for Data that change be changed, And a text box for the data that can change?