I just posted a question about using VLookup and that was answered, but now we want to try and change our Excel file to use VBA. We want to be able to have the Vlookup function in my module1 run and populate the same cell where the end user entered 1 the number.
So, using the attached Excel file as an example:
Let's say I enter 1 in column F, I want the VLookup to run and replace my 1 with Windowsills. If I enter 3 in column F, then I want the VLookup to run and replace my 3 with Bath Tile.
If I enter 3 in column G, then I want the VLookup to run and replace my 3 in column G with Gold in column G.
As you will see, I have sort of started and I get it to replace but then I get the attached error. In my code I have it hard coded to be cell F4, but I would want it for any row in the entire column (F, G etc.)
I'm using the Worksheet_Change(ByVal Target As Range) function to sense when a cell is changed. In my attached worksheet I have code in Sheet1 and in Module 1.
Thank you in advance.