Hi,
Based on my research, I found a very similar thread in other forum. Was this macro no longer working as expected after installing MS14-082 Microsoft Office Security Updates for December 2014?
If yes, please try these hotfixes for this issue have been released in the March 10th 2015.
http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/11/forms-controls-stop-working-after-december-2014-updates-.aspx
If no, we may try to debug the code, I'm not familiar with it. I recommend you post question to MSND forum for Excel
http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
Regards,
George Zhao
TechNet Community Support