VBA Message box to display column titles based upon totals

[gratefulwork]

Hi there,

I have a spreadsheet that contains 9 employees, and their sales in thousands over a period of 10 years. Their total sales over the 10 year period are totaled at the bottom. What I am looking to do is have a message box that pops up and displays the names of the employees who have total sales over 500. So basically the code will look for values over 500 in the bottom row, and then take the corresponding names of the employees and display it in a single message box. I am new to VBA, and have Googled around on how to get started with this but I have not found anything. I have attached my worksheet below, any help is greatly appreciated.


Employee Sales.xlsm