Microsoft just released an update to the VB Editor for the Mac 2016 version of Excel. New features include: - Edit and debugging toolbars. - Updated Project, Properties, Immediate, Watch,. Open VBA Editor. Windows shortcut. This shortcut opens the Visual Basic Editor. 222 Excel Shortcuts for Windows and Mac. Download 200+ Excel Shortcuts. Get over 200 Excel shortcuts for Windows and Mac in one handy PDF. Comments welcome! Read this before posting a question. Video training; Function Guide. Excel visual basic free download - Real Studio, Objective-Basic, Digital Future Text-to-Speech SDK, and many more programs.
Active2 years, 11 months ago
Edit Visual Basic In Excel 2016
My visual basic editor only allows me to type in one column. In other words, only one letter per line. Please see the image below. How do I fix this? (visual basic for mac)
Community♦
Victor RanuVictor Ranu
2 Answers
This is a bug in Excel. To fix this, you simply need to update Excel. Click 'Help' > 'Check for Updates', then close Excel. Next, click the 'Check for Updates' button in the Microsoft AutoUpdate window, and select for Excel to update. After updating, when you reopen Excel the problem will be fixed.
cameronroytaylorcameronroytaylor
Never mind, found the answer here : http://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/visual-basic-support-in-mac-2016/4afbba04-4435-4970-8b02-40da006a590e?auth=1
MS has no plans to push the VB editor forward on the Mac...Wonder if they put that on the glossy brochure for office 2016?
lincolnadymlincolnadym44911 gold badge66 silver badges1616 bronze badges
Not the answer you're looking for? Browse other questions tagged excelmacosvisual-studioexcel-vbavba or ask your own question.
Active1 year, 6 months ago
I am having this issue with Visual Basic Editor for Excel 2016 -- I have updated my computer and Excel to the latest version.
Pᴇʜ31.7k66 gold badges3030 silver badges5656 bronze badges
formicamanformicaman
1 Answer
Try update again your MS Office, this should solve your problem :
- Open any Office application:
- Make sure your Mac has a working internet connection
- Go to the Help menu and choose Check for Updates
- Let AutoUpdate check for and install updates
SOURCE : https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/visual-basic-editor-single-column-bug/3d8d114d-7c26-4deb-b893-c55c400397b4
Léo R.Léo R.2,71511 gold badge66 silver badges1919 bronze badges
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.