有没有办法在Access和Excel 2007中获得完整的IntelliSense for VBA? [英] Is there a way to get full IntelliSense for VBA in Access and Excel 2007?

问题描述

在VB.NET中，只要您开始键入，便会弹出IntelliSense，这将为您提供当时可以使用的所有功能的完整列表.但是，在 VBA 中使用IntelliSense对我来说不会起作用，直到您使用的零件后面加上句号为止.例如，我进入Excel 2007中的VBA编辑器并开始输入单词"Range"，但是直到我键入"Range."后，IntelliSense才会出现，然后它会给我列出我可以做的事情.在那个时候使用.

In VB.NET, the IntelliSense pops up as soon as you start typing which gives you a pretty full list of things you can use at that moment. The IntelliSense in VBA however, doesn't kick on for me until a period is put after the part you're using. For example, I go into the VBA editor in Excel 2007 and start typing the word "Range" but the IntelliSense doesn't come up until I type "Range." after which it will give me a list of things I can use at that point.

有什么方法可以使VBA编辑器中的IntelliSense更快出现，从而使我能够看到可以使用的东西列表，例如Davg，DCount等?

Is there any way to make IntelliSense come up sooner in the VBA editor, so that I'm able to see a list of things that can be used like Davg, DCount, etc?

推荐答案

否，但是您可以先键入Excel.在此之后放一个句号，您会发现比以往任何时候都想了解的更多有关Excel的信息.

No, but you can type Excel first. Put a period after that, and you'll find out more than you ever wanted to know about Excel.

与Access相同.键入Access和一个句点，您将在其中找到DCount.

Same with Access. Type Access and a period, and you will find DCount there.

这篇关于有没有办法在Access和Excel 2007中获得完整的IntelliSense for VBA?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！