VBA Challenge 4 - an improved guessing game

Take a few minutes to go over your VBA guessing game from the last challenge. Step through the code (using Excel's Debugging tools) and make sure that it works as you think it should.

Your challenge is to modify your guessing game so that it remembers how many guesses a player takes to get the number. When they guess the correct answer, it should respond with "Correct! It took you 6 guesses." (or however many it actually took them!)