title: Is there a way to get full IntelliSense for VBA in Access and Excel 2007?
body: <p>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 <em>VBA</em> 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 "<code>Range</code>" but the IntelliSense doesn't come up until I type "<code>Range.</code>" after which it will give me a list of things I can use at that point. </p>
  
  <p>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 <code>Davg</code>, <code>DCount</code>, etc?</p>