VBA - Additional Controls Dialog Box "MISSING"

Grizlore

Active Member
Joined
Aug 22, 2006
Messages
257
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
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Grizlore

Active Member
Joined
Aug 22, 2006
Messages
257
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

New Member
Joined
Jul 31, 2009
Messages
5
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

Active Member
Joined
Aug 22, 2006
Messages
257
must be a software issue then and therefore Microsoft's problem to sort... no?
 

amin esmaeili

New Member
Joined
Jan 8, 2013
Messages
3
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

New Member
Joined
Jul 28, 2009
Messages
1
THANKS: amin esmaeili.
But why these controls disappear?
 

amin esmaeili

New Member
Joined
Jan 8, 2013
Messages
3
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

New Member
Joined
Jun 4, 2013
Messages
2
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

New Member
Joined
Apr 10, 2014
Messages
2
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
 

Watch MrExcel Video

Forum statistics

Threads
1,099,536
Messages
5,469,270
Members
406,646
Latest member
jasondabsher

This Week's Hot Topics

Top