- 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,.
- Visual Basic IDE with the full editor, including multiple code windows, breakpoints, watches, the Object Browser, and more will be delivered as an update later this fall. This VB IDE feature will be available only for Word, Excel and PowerPoint for Mac.
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,.
Is there any VBScript editor that I can run on mac? Or is VBscript something specifically for PCs?
3 Answers
On my Mac, I use TextWrangler for creating VBScripts. It doesn't support VBScript implicitly (highlighting of all keywords), but it has nice indenting, search replace etc. functions. A good all round text editor, also for code.
Of course you can not run the code on OSX, VBScript is for Windows environments only.
TextWrangler (free) can be used to edit VBScript. It does give basic syntax highlighting, strings, keywords etc, but it is not aware of App-specific object models such as the Excel Object Model, which I'm guessing is the reason you want to edit VBScript on a Mac.
Textastic ($7.99 on the AppStore as of today) has even better syntax highlighting than TextWrangler. It is syntax highlighting for ASP.NET VbScript, and that mode also works pretty well for VBA.
The built-in Visual Basic Editor in Office 2016 (for Mac) is probably the worst thing ever: no intellisense, no search/replace, no indenting and syntax highlighting is way less complete than TextWrangler or Textastic.
As far as I know VBScript is just for PCs (Windows Scripting Host) and IE.
Andrew Cooper