VBA - Additional Controls Dialog Box "MISSING"

[Grizlore]

Additional Controls Dialog Box refuses to display

I have a problem trying to add additional controls to the Controls toolbox

The two methods I've tried

1. Right click on the controls toolbox , click Additional controls

2. Menu, Tools, Additional controls

Neither of the above produce a dialog box containing the list of additional controls to choose from.

I am running Excel 2007

Any ideas would be appreciated

 

[Andrew Poulsom]

Maybe this will help you:

http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/ac7f7e79-f171-4a8b-8329-ede176669802

 

[Grizlore]

Thanks Andrew,

I did have a little look there before I posted here. However I didnt get a solution, only a few long and convoluted workarounds.

I would like to resolve this, so the search continues

 

[zaphod60148]

I have this same issue in excel 2003 at work. I have found no solution yet and our IT dept went so far as to reformat my HDD and reinstall both windows and excel. They even upgraded me from excel 2000 to excel 2003 at the same time. Nothing helped.

So, if anyone finds a solution to this they may become world famous.

Still looking myself.

 

[Grizlore]

must be a software issue then and therefore Microsoft's problem to sort... no?

 

[amin esmaeili]

Hi dear friend
i wish all is well in your country, so i have had the same problem, today i can find it,s solution, let's do this.

1-click on start menu( in the left on your desk top )
2-drage a shortcut of Microsoft Excel in your desktop
3-Right click on it and choose Properties then click on compatibility Tab
4-set check on run this program in compatibility mode for
5-Apply then OK

Now open your Microsoft Excel or(Word,......) , You can see everything is OK and additional Control box is working well

This problem usually happen when we change or config our Microsoft to new version( 2003 to 2010 ,.....)
best regards
M.A.Esmaeili

Chemical Engineer

 

[omnibuster]

THANKS: amin esmaeili.
But why these controls disappear?

 

[amin esmaeili]

hi Dear friend

In my opinion, this problem will appear when we want to upgrade our Microsoft Office (e.g 2003 to 2007 0r 2010)
and to be honest i don;t really know why it's happen and this is a big problem but don't worry if you do my explanation , you can solve .

 

[MiguelPmcg]

IT TOTALLY WORKED!!!!!
thank you so much!
Here in the office i'm now the excel master hahahaha
This problem has bothered us for a while... i had to program from scratch my own calendar.

Miguel form Perú.

 

[Davoodnjn]

Hi dear friend
i wish all is well in your country, so i have had the same problem, today i can find it,s solution, let's do this.

1-click on start menu( in the left on your desk top )
2-drage a shortcut of Microsoft Excel in your desktop
3-Right click on it and choose Properties then click on compatibility Tab
4-set check on run this program in compatibility mode for
5-Apply then OK

Now open your Microsoft Excel or(Word,......) , You can see everything is OK and additional Control box is working well

This problem usually happen when we change or config our Microsoft to new version( 2003 to 2010 ,.....)
best regards
M.A.Esmaeili

Chemical Engineer

Thank you So much Amin Jan!
I had been struggling with this issue for a while now and have tried all sorts of methods to resolve it. This was the only one that actually worked!

Thanks Again,
Cheers
Davood