Vlookup Question; VBA Code to Lock Cells

[midfielder1]

Dear Members,
I have a spreadsheet that I use to track cost and depreciation expense for assets placed in service. The user selects an Item ID from the inventory drop down list, then assigns it an internally generated serial number. The item description and corresponding cost fields are autofilled using a Vlookup formula. Once this new item is saved, the spreadsheet starts calculating monthly depreciation expense. My problem is this, annually I update the Item ID list which may change the cost for some of the items put into service during prior years. For example: if in year one the cost of an item is $8,400.00. In year two the the company's new cost for this item may be $10,000.00.
Question: How do I keep the original cost for the item from year one in the cell, $8,400.00, when the value in the inventory table, that the Vlookup formula references, gets update to the new value of $10,000.00 in year two? I'm using the following code to keep date previously entered from being changed after the data is entered and saved:

Please Login or Register  to view this content.

Thank you in advance for any help you can provide!

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)