vba VBA中是否有自动完成快捷方式?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/12690377/
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 14:07:52  来源:igfitidea点击:

Is there an auto complete shortcut in VBA?

excel-vbavbaexcel

提问by BuZz

I am pretty sure there is an auto complete feature in the Excel/VBA editor but can't seem to find it. (e.g. Ctrl+Space in Eclipse).

我很确定 Excel/VBA 编辑器中有一个自动完成功能,但似乎找不到它。(例如 Eclipse 中的 Ctrl+Space)。

Or am I dreaming it ?

还是我在做梦?

回答by GSerg

There is, and it's Ctrl+Space.

有,而且是Ctrl+ Space

If you press that and auto complete does not happen, then there are multiple possible choices and you are presented with them.

如果您按下那个按钮并且自动完成没有发生,那么有多种可能的选择并且您会看到它们。

At this point, you can navigate through the options using the arrow keys and and then press Tabto select your choice.

在这一点上,你可以通过使用箭头键的选项浏览,然后按Tab选择你的选择。

Also see Is there a way to get full IntelliSense for VBA in Access and Excel 2007?, which is almost a duplicate.

另请参阅是否有办法在 Access 和 Excel 2007 中获得 VBA 的完整 IntelliSense?,这几乎是重复的。