This sounds like a natural for use of the Worksheet_SelectionChange event, unless for some reason, you can't use an .xlsm file.

You do realize you didn't attach the spreadsheet to your original post, right?