The example I posted does what you want to do. I'm having a bit of trouble getting your Test file to work on Excel 2011 for Mac. Doesn't seem to like the ActiveX controls, plus I think there are other problems with the code.

You would just need to put the code on events instead of buttons.