Excel 2007 VBA tools RRS feed

  • Question

  • It has been a while since I used VBA code in Excel. In my previous job, when I type code it automatically offered a drop down list of choices for the commands. That doesn't happen in the application I am using now. How do I activate this feature?


    Thanks, Water Girl
    Tuesday, September 6, 2011 8:41 PM


  • Two things:


    1. In VBA  Tools > Options > and make sure all the "Auto" checkboxes are checked
    2. Make sure you DIM your variable so VBA knows which choices to present

    Tuesday, September 6, 2011 9:47 PM