title: VBA autofill functions/variables while typing code
body: <p>I get used to C++/C# environment where you type code and functions/variables can be inserted by selecting them by "TAB".</p>
  
  <p>On daily basis I work on excel/access and atm I'm working on big project. My class module has around 100 variables, mostly strings. Is there any option in VBA to auto fill or suggest variable within class module while writing code? For example:</p>
  
  <p><code>CurrentWB.Sheets(PDSheet).Select</code></p>
  
  <p>CurrentWB is set for Workbooks. After dot it doesn't suggest <code>Sheets</code> and after typing brackets it doesn't suggest <code>PDSheet</code> and so on.</p>
  
  <p>Any advise is helfull.</p>