none
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,


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

Answers

  • 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

    gsnu201106
    Tuesday, September 6, 2011 9:47 PM
    Moderator