A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
Not long ago, Microsoft had an update to Excel that broke a lot of ActiveX Control Boxes. If you are having this problem, Microsoft has a fix and a support article.
Excel Cannot Insert Object ActiveX – Microsoft Support Document: http://support.microsoft.com/en-us/kb/3025036
Several solutions are offered in the article. Te main solution is to ensure all parameter types are VBA friendly. Delete TEMP *.exd file if necessary.
Kevin mentions that he avoids them like the plague. Jordan mentions that they are a leftover from Visual Basic 6.0 and that they don’t play nicely with Excel
Kevin Jones tends not to use Controls on a spreadsheet other than Command Buttons.
This is more aesthetically pleasing and they are much easier to manage and maintain.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Get the FREE Excel Power User Guide