Excel VBA 编辑器的替代品?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/9469527/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-08 12:41:03  来源:igfitidea点击:

Alternative to the Excel VBA Editor?

excelvbaideeditor

提问by tyrex

Is there an alternative to the usual Excel VBA Editor, which is accessible using Alt+F11 in Excel?

是否有可以在 Excel 中使用 Alt+F11 访问的常用 Excel VBA 编辑器的替代方法?

I prefer the Visual Studio IDE, such as for when I develop in C#. An example of its deficiencies for me includes the simple fact that there is no keyboard shortcut to stop the debug process, although I feel that there are other issues with the Excel VBA editor as well.

我更喜欢 Visual Studio IDE,例如当我用 C# 开发时。对我来说它的一个不足之处包括一个简单的事实,即没有停止调试过程的键盘快捷键,尽管我觉得 Excel VBA 编辑器也存在其他问题。

采纳答案by Govert

You might consider using VB.NET instead of VBA for your Excel development. Excel-DNA(which I develop) is an open source framework for integrating .NET in Excel, which tries to make the VBA to .NET conversion as easy as possible.

您可能会考虑使用 VB.NET 而不是 VBA 来进行 Excel 开发。Excel-DNA(我开发的)是一个用于在 Excel 中集成 .NET 的开源框架,它试图使 VBA 到 .NET 的转换尽可能简单。

Then you can use any editor for the VB.NET (or C#) code, including the Visual Studio Express editions or SharpDevelop.

然后,您可以对 VB.NET(或 C#)代码使用任何编辑器,包括 Visual Studio Express 版本或SharpDevelop