Lookup then Replace data?

[Scubaru]

I'll try to explain this the best I can.

I want to produce an interface to track personal items, I'd like to scan a barcode and see all the info pop up (easy enough). However I'd then like to be able to adjust the data.

Example, let's say I scan my tent and all the info pops up via Hlookup or Vlookup. I can see date purchased, price, brand, etc. but I also see a cell for last date used. I'd like to be able to click that cell and change that information without digging into the data table to change it. With the lookup functions that cell is only mirroring the data from the table. Is there a command/function or even a pre written macro for this?

Thanks!

[Kaper]

In the situation described probably the most natural way is to display all the info not in the sheet but rather in the userform.
Of course one can use equivalent to worksheet functions (their names are the same, like: worksheetfunction.vlookup is exactly VLOOKUP etc.) to populate the userform.
The form shall have 2 buttoms "Close" and "Update".
And that's it.
Shall be realy easy code.

[Scubaru]

In the situation described probably the most natural way is to display all the info not in the sheet but rather in the userform.
Of course one can use equivalent to worksheet functions (their names are the same, like: worksheetfunction.vlookup is exactly VLOOKUP etc.) to populate the userform.
The form shall have 2 buttoms "Close" and "Update".
And that's it.
Shall be realy easy code.

I have only ever made one userform in my life and it was a copy and paste deal, so the code beyond the interface is greek to me. I am trying to learn it but I don't know where to start, is there perhaps another way or could someone generate the code and explain how to implement it into excel/userform?