Color cell by matching cell when double click

Hi guys,

I’m new here and beginner with VBA. I hope that someone can help me to solve my problem
I have various names in sheet 1. By double clicking any of the names the program will search in sheet 2, column A:A for the matching name. It works with a message box “value found” but how can I go to the found cell (in sheet 2) and color it in red (for example)?

Please Login or Register  to view this content.

Thanks,
Stefan