title: Autocompletion in Excel 2010 VBA Editor
body: <p>I'm new in VBA. In the editor in Excel 2010 there is the opportunity of an autocompletion by pressing CTRL + Space.</p>
  
  <p>But sometimes, it doesn't work.. For example when I type in "ActiveSheet." I can't examine the possible methods and variables the object have..</p>
  
  <p>But when I type in:</p>
  
  <pre><code>Set sheet = Workbooks.Open(file, True, True)
  sheet.
  </code></pre>
  
  <p>and hit CTRL+Space I can see all possibilities..</p>
  
  <p>Thanks for your help!</p>