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
Is there an auto complete shortcut in VBA?
提问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?,这几乎是重复的。