Looking for some VBA programming help with a search function

[Jede]

I am completely new to VBA and I don't really know where to even begin on this. Basically what I am trying to accomplish is the workbook I am working on has 3 columns and a search cell function. In the search cell would be a manual or scanned input to search Column 1 for the value and highlight the cell in Column 1 if there is a match(No highlight if no match). The first column has a specific number in each column. What I would like to happen is when the manual/scanned input is put into the search box, for it to automatically paste the input into Column 2 and also highlight the column 2 box IF the value is matched to Column 1(Do nothing if it does not). (Column 3 is a match verification if Column 1 Row x matches Column 2 Row x.) I attached 4 files showing the progression of what I would like to accomplish.

Thank you in advance for any guidance!

[Leith Ross]

Hello Jede,

I have added the macro below to the attached workbook. This will be triggered when a value is entered into cell "I7". I added Conditional Formatting to columns "C:D" to add the highlight when there is a match.

Sheet1 Change event Macro

Please Login or Register  to view this content.

[Jede]

Leith, Thank you so much for the quick response! I tested this out and it seems to work almost exactly as I want it it to. I may not have explained very well though as this all is very new to me. Once you go back to the search function it clears the box from Column 2. Basically I am trying to make it so the input in Column 2 stays both text and highlighted when searching. eventually looking like this(see Attachment)

[Leith Ross]

Hello Jede,

I removed the line that clears the data when an entry is made. The attached workbook has the change made to it

[Jede]

Leith, thanks again so much!

[Leith Ross]

Hello Jede,

You're welcome.