Visual Basic for Aplications opens Blank with huge letters and no tree, or bars is visible, how to solve?

Question

In Excel and other office tools, as i click the visual basic button, to enter the visual basic for aplications , the only visible thing was a blank page with huge leters, no tool bars, no tree, nothing.

Answer 1

Hi Tiago,

Thank you for posting, We really appreciate your idea's and your suggestions is well taken regarding this problem you encounter. This will be also review and apply this steps from different user. If you have any further questions If the answer is helpful, please click "Accept Answer".

Best regards,

Jansher

Answer 2

Ok, so I' ll try to explain the solution. Sorry in advance for any mistypes. After several hours, I understood that there was a conflict with language.

Excel and Word, etc... were in Portuguese , and Windows also, as soon as I changed the language in Windows to US English, it worked.

But I wanted to maintain Portuguese the Windows language, so I went to Word, for example:

File -> Options -> Language and added US English , moving it to preferred .

Then I exited, closing all instances.

After that , upon opening, the language was English. I did the same steps but changed Portuguese (PT) to preferred and exited, closing all.

After this , Excel was in PT - PT Portuguese, and VBA was in US English .

Conclusion : because VBA does not have a Portuguese language option , or at least not on my PC, switching from US to Portuguese gave VBA a valid language startup and run. Hope this can be helpful; it took me quite some time, and I did repairs and reinstallations , but nothing worked.

Hope it helps