Pages

Wednesday, May 1, 2013

Solution to Missing / Not showing "Additional Controls" in User Form Excel 2007 Visual Basic

I decided to start taking notes and track our daily expenses by creating a CASH FLOW template via Microsoft Office Excel 2007.

So I started making the template until I found out that I couldn't bring the "Additional Controls" window out. After I right click on the toolbox and select additional controls, nothing happens. I can do this smoothly on my print shop's PC, but I can't do this on my home computer and it frustrates me. I have been troubleshooting this issue for almost a day now. I'm trying to achieve this so I can create a calendar popup within my Excel sheet. So I searched all over the internet for a solution but I couldn't find any. As far as my searching goes, I went ahead and cleaned my registry, registered some .dll files, ran Excel as Administrator, installed Excel add-ins, updated Windows 7, restarted Office 2007 and my PC, followed some advice/workarounds online yet still nothing ever worked. But with all the search that I have done, there was always one common factor to this issue, Windows USER PROFILE. I was about to give up, but I tried something for the last time. I changed the compatibility mode in Excel for Windows XP Service Pack 3, then it fixed it!

My PC build:

Windows 7 64 bit Service Pack 1
Microsoft Excel 2007

What I did was right-clicked on my Excel 2007 shortcut icon, the selected properties. This window will popup right after.


Make sure you select "RUN THIS PROGRAM IN COMPATIBILITY MODE FOR WINDOWS XP SERVICE PACK 3". That fixed the issue. At least to my computer. I hope this little trick will also help others that are having the same issue. I'd be happy to know if this helped you, just leave your comments below or give it a +1. Thanks!