CODEWITHSUNDEEP
vbaidems-office
Mark Lalor
Mark Lalor

Reputation: 7907

Visual Studio Macros Editor

Is there a way to change the macro editor from this default one:

screenshot

It feels like such a downgrade from Visual Studio 2010. Can I configure Office to use that instead?

Upvotes: 7

Views: 2729

Answers (2)

HackSlash
HackSlash

Reputation: 5812

There are things you can do to improve it:

  1. Tools > Options > Editor : Uncheck "Auto Syntax Check"

  2. Tools > Options > Edit Format: Customize the colors and font

  3. Install the VBA Rubberduck: http://rubberduckvba.com/

The RubberDuck does auto-indent for you. It also helps you with "unit testing, source control, from code inspections, and refactorings"

Upvotes: 0

Davide Piras
Davide Piras

Reputation: 44605

no there is no way to my knowledge, VS.NET does not support VBA.

what you can do if you are creating a new word or excel file is create a managed office solution, having installed the VSTO 2010 (Visual Studio Tools for Office) you are able to create managed documents which are handled inside VS 2010 and the automation language is not VBA anymore but C# or VB.NET instead.

this is a viable solution for new files, for legacy files either you convert them if they are small or you keep old VBA code and old VBA editor as in your picture.

Mark I wish MS made a tool to convert from the old format to the new one! :(

Upvotes: 3

Related Questions