Results 1 to 8 of 8
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Additional controls not available (Office VBA)

    I have a client that told me that their PC crashed. Once up and running again, they re-installed office completely. Once that was up, they noticed that the VBA editor did not provide the additional controls when a user form is designed. Apparently it is all greyed out.

    Any reason for this. Must some reference be active to get additional conrols?

    Any advice is welcome
    TX
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Additional controls not available (Office VBA)

    Are you absolutely sure that a userform was active? If a module is active, Additional Controls will be grayed out.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Additional controls not available (Office VBA)

    In addition to Hans' point, AFAIK the Additional Controls option is greyed out if the toolbox is not visible.
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Additional controls not available (Office VBA)

    Hi Hans and Rory,

    I do not know if the user had a module or a user form active. I just got the message that they said the additional controls was not available, where as it used to be available before the crash!

    I will advise them on both your suggestions. I too noticed now that the option is grey if a module ia active, or s the user form is active the toolbar must also be there!
    Cheers
    Regards,
    Rudi

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Additional controls not available (Office VBA)

    I have since been informed of the solution to this clients problem.

    It had to do with unregistered dll files. The problem originated when the PC crashed and the user uninstalled Office which unregistered the dll files (incl. those for additional controls in VBA). With the re-installation, the dll files were not re-registered and this caused the controls to be greyed out and unavailable. It was then necessary to use the run command to reregister the dll's by typing Regserv [Name].dll to reactivate them. After the necessary files were active the additional controls were again available in VBA.
    Regards,
    Rudi

  6. #6
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Additional controls not available (Office VBA)

    Rudi

    I realize the horse has already bolted on this occasion, but if you get similar client problems in the future, it might be worth having Emsa Register Dll Tool: Information and Dll Registration Tool for Windows in your toolbox. It's <img src=/S/free.gif border=0 alt=free width=30 height=15> and saves all that Start -> Run -> Where the <img src=/w3timages/censored.gif alt=censored border=0> is it! stuff.

    Alan

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Additional controls not available (Office VBA)

    Cheers Alan...

    Boy, you are really the Santa Claus of the lounge currently, dishing out all this freeware utilities....
    Regards,
    Rudi

  8. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Additional controls not available (Office VBA)

    I'm very generous when it comes to giving away other people's stuff. <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

    Alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •