8468

VBA userform toolbox additional controls dialogue window not showing

While using MS Excel (Outlook, Word, or Power Point as well apparently) and using VBA, I create a userform. The toolbox shows up showing controls tab and 16 icons representing various controls. When I right click in some empty space in the tool box control area, a menu comes up listing "additional controls" at the top and two greyed out options below it. When I select "additional controls" a spinning blue circle appears briefly then disappears and nothing happens. It is my understanding that a dialogue box should open at this point and I should be able to select some additional controls.

<img src=https://www.e-learn.cn/content/wangluowenzhang/"https://i.stack.imgur.com/Go3jJ.png" alt="enter image description here">

I have spent about a day scouring the net and various solutions to the problem. I noticed the problem while trying to follow a video on how to data scrape for my personal project which I asked for help here.

What I have tried

creating a user form on another computer and then importing it to this one. no success.

Repairing MS Excel. This resulted in a full reinstall I believe as I had to re enter my product key. No success

Resetting various registry key as mentioned in this article. no success.

KB 369383 as mention as part of the process above. no success.

Issue described here but no solution, just a work around to something to what the person was trying to add.

Setting MS Excel to run in compatibility mode...but there was no compatibility mode listed as an option under properties for the desktop icon.

Running as administrator even though my windows account has admin rights. no change.

Cleaning the registry with both ccleaner and wise registry cleaner.

Running Excel in safe mode using excel.exe /s. confirmed with (safe mode) in the title bar. No success.

My System

Windows 10

MS Office Professional 2013 - 32

(Note, no crystal reports added that I am aware of)

Additional Info

I tried it on another windows 10 machine running same version of MS Office and it worked there, so it should not solely be a windows 10 issue. My machine was an upgrade from windows 7 - 64. The other machine was an upgrade from windows 8.

So I just created a new windows user account and I tried it in there and the dialogue box comes up for that account. It just will not come up for my account. Windows really does personally hate me 8) hehehe. At least now we know that its SOMETHING to do with my user account/profile.

Answer1:

I found a solution to 'my' problem after spending 2-3 nights over this. It turned out to be a very simple and not-so-intuitive fix.

My problem was that when I right-click on the Toolbox, I do not even get to see the "Additional Control" option in the menu.

Click on the userform, so that its selected. Now go to Tools and Additional Controls is no longer greyed out. :)

Recommend

  • FB Login : Don't know how to get response after a successful login
  • Dealing with the open/save/cancel dialogue window in IE when using VBA
  • Adding class in table in ckeditor for rails application
  • How can I use Node / Cheerio (or something else) to scrape a global variable from a site?
  • Code that works once/ twice either by F5 or F8 but then gets multiple errors
  • Scraping landing pages of a list of domains [closed]
  • How to display rendered html content in text widget of tkinter in python 3.4.x
  • Displaying field specific validation error messages in jqGrid (server-side validation)
  • Can you trust mysql_insert_id? [duplicate]
  • Reactjs require not defined
  • Associate git repo with existing fork network
  • Add a div to replace Video after Video Plays Through
  • Are there any supported high bit-depth video or image formats in DirectShow
  • Converting raw frames into webm live stream
  • Should I be afraid to use UDP to make a client/server broadcast talk?
  • How do I translate LR(1) Parse into a Abstract syntax tree?
  • SIP API media codecs
  • how to populate a SQLite database and use that database in phonegap?
  • C++ Single function pointer for all template instances
  • Can I have a variable number of URI parameters or key-value pairs in Laravel 4?
  • Does Apportable support to build library binary (.a/.so)?
  • Creating a DropDownList
  • Git describe fails to return most recent annotated tag
  • Authentication in Play! and RestEasy
  • Jenkins: FATAL: Could not initialize class hudson.util.ProcessTree$UnixReflection
  • How to match http request and response using Jersey ContainerRequestFilter and ContainerResponseFilt
  • Test if a set exists before trying to drop it
  • Setting up SourceTree to merge unity3d scenes with UnityYAMLMerge
  • Switching to Release Build causes runtime error in Web Reference
  • Django: Count of Group Elements
  • Join two tables and save into third-sql
  • How to model a transition system with SPIN
  • ORA-29908: missing primary invocation for ancillary operator
  • QuartzCore.framework for Mono Develop
  • Java static initializers and reflection
  • embed rChart in Markdown
  • How to get NHibernate ISession to cache entity not retrieved by primary key
  • How can I use `wmic` in a Windows PE script?
  • Unable to use reactive element in my shiny app
  • Converting MP3 duration time