VBA that does what an Index & Match does

Hi Experts
I have an excel file where I have one column where I have an Index and Match formula to populate the description from another work sheet

It works perfectly, but because multiple people use it, the formula keeps getting deleted and file saved

I have tried Format Change and Lock and then Protected the worksheet, but then I have other issues where rows can't be added or people like to go to the last row and just type and it adds to the table, but once protected they can't do all that

So I was wondering if the Index and Match can be written as a VBA so when the Product Code is entered in Column F, the VBA will do the Index and Match and populate Column G with the description

The below is the Index and Match formula that I am using

Please Login or Register  to view this content.

I have also attached a sample excel file

Regards
Rah

Paste the below into the Shedule worksheet module and it will do the same as your INDEX/MATCH formula but will leave a hardcoded value in the cell rather than the result of a formula.

Please Login or Register  to view this content.

This version will not throw up an error the value entered is not found on the Database sheet, and will clear the cell if it already holds a value.

Please Login or Register  to view this content.

BSB

Thanks BSB
It worked

Much Appreciated

Rah

Hi CheeseSand
No it's not the only worksheet event, I had another, but had to remove it

Please Login or Register  to view this content.

Hi WDB
Thanks for that, entering multiple codes wasn't a requirement, but a nice to have

How would the codes need to be separated for it to work?

Ragards
Rah

[QUOTE

Note that the above caters for multiple product codes being pasted into the column. Not sure if that's required/relevant.

WBD[/QUOTE]

This is awesome to have... Question: How would multiple product codes will be entered for it to work? Do the product codes need a seperator?

Thanks CS. Much Appreciated