Homework assignment done, I think: I just opened up a blank new spreadsheet, went into VBA, clicked on 'view code' icon in the Project - VBAProject window and pasted your code. I tried to run the macro but it didn't appear in the list until I took out the '0' between parentheses. Once it was removed, I was able to run the macro and have the message box appear.