none
VBA Missing from Excel 2016 RRS feed

  • Question

  • Hi 

    Installed Brand New Office Home & Stud & Excel 2016 but there is NO VBA. 

    I just get Debug errors running any kind of code.  

    Installed the 64 & 32 Bit Excel 2016.  

    How do I get VBA loaded in this Excel?  

    Thanks 


    Wednesday, September 6, 2017 9:02 PM

All replies

  • Hi,

    hope this helps:

    http://www.excel-easy.com/vba/create-a-macro.html

    Wednesday, September 6, 2017 9:09 PM
  • Hi,

    In the VBA editor, go to  Tool | References and uncheck any libraries marked as Missing.

    Wednesday, September 6, 2017 9:12 PM
  • Hi,

    If you cannot find VB Editor, 
    1) [File] > [Options] > [Customize Ribbon]
    2) check [Developer]
         
    3) you can find Developer tab on menu ribbon
         

    If I misunderstand your question, please explain more details about your issue.

    Regards,

    Ashidacchi


    Wednesday, September 6, 2017 10:15 PM
  • Hi,

    Please check if the information of Ashidacchi was helpful.

    Do you use MSI installer to install Office in your environment? If yes, please go to Control Panel- Programs and Features- right click Office and select Add feature, please check if you don't install VBA editor in advanced features, please check the VBA editor and install it.

    Please let us know if you would like further assistance. 


    Regards,
    Emi Zhang
    TechNet Community Support

    Please remember to mark the replies as answers if they helped.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Friday, September 8, 2017 8:39 AM
    Moderator