3

I've seen posts for how to comment / uncomment blocks of VBA code in Excel but they all seem to be related to Excel for Windows. I can't figure out a similar method for commenting large blocks of code in Excel for Mac 2016. Please help.

Here is the related post I found for Windows: How to comment and uncomment blocks of code in the Office VBA Editor

Martijn Pieters
  • 1,048,767
  • 296
  • 4,058
  • 3,343
Brent Kumfer
  • 31
  • 2
  • Just a note: the VBE (the VBA IDE) has nothing to do with its host - it's the same editor whether you're in Excel, Word, Outlook, PowerPoint, Sage300, AutoCAD, or whatever. The VBA editor on Mac is an entirely different thing though, even more severely under-featured than the VBE. – Mathieu Guindon May 24 '17 at 21:15

1 Answers1

1

The VBA editor in Office mac 2016 is severely broken. Office mac 2011 did have the ability to comment/uncomment code blocks.

MS have promised a fix, but none has yet arrived:

Bring back a fully functional VBE (Visual Basic Editor for VBA)

ThunderFrame
  • 9,352
  • 2
  • 29
  • 60
  • "fully functional" as in "still won't support plug-ins but will let you comment code blocks"? – Mathieu Guindon May 24 '17 at 21:16
  • @Mat'sMug who knows, maybe the patch will be .NET Core Editor for Office (with a VBA converter), and debut on the mac. Or maybe not. – ThunderFrame May 24 '17 at 21:20
  • Since the Mac Office 2016 October release (October 10, 2017 V15.39.0 build 17101000), the VBA editor is improved a lot. See [release notes](https://support.office.com/en-us/article/Release-notes-for-Office-2016-for-Mac-ed2da564-6d53-4542-9954-7e3209681a41?ui=en-US&rs=en-US&ad=US) – R. Oosterholt Dec 07 '17 at 11:15