Is it possible to write Excel VBA Code in Visual Studio

The best you can do is bend the office Visual Basic Editor (VBE) tool to your liking. If you stay in it’s native environment you get the full power of error detection, Intellisense, live code running, etc.

My tips…

1. In the VBE go to Tools > Options > Editor tab.
   Turn off ‘Auto Syntax Check’. You still get code highlighted errors but no annoying popups.

2. Go to the Editor Format tab and change the Font to Consolas (Western), Size 11.

3. For code indenting install the awesome, free, Code Manager. It adds some sick keyboard shortcuts.
   

4. Make the Edit toolbar easily accessible for code commenting/uncommenting.
   

5. Use Rubberduck to add unit testing, source control, code inspections and refactoring functionality.

With those simple changes you end up with a half way decent, useful, and keyboard friendly environment to write your visually appealing code. 😀