Using an external text editor to edit VBA code

AkelPad has VB scripts enabled, so try to ask at Akelpad site about it. Also PSPad has.


Recently I found Text Edit Anywhere, and using one hotkey I can now get a notepad++ editor window synchronized with the Excel code editor.

The only problem I did not manage to solve so far is that Cyrillic letters fail to pass from notepad++ to Excel: as soon as I save the script once, all they are converted to question marks (although copy-paste from notepad++ preserves the letters). Other than that I'd highly recommend the solution: it allows you to edit text in any program with any editor.


Sublime Text 2 can work with VBscript as well. You'll need this VBscript Package (github) to access the syntax.

enter image description here