Hello all,
I'm a new user teaching myself the VBA language, been working on it a little less than a year.

This Spring I had my computer reformatted at my college and apparently I got a new version of excel loaded on.

I remember previously when I started typing in an object it would list all the members of it for me. For example when I typed in sheets(1). it would show me the list of all the commands I could have after the . (activate, add comment, value). Now when I type in sheets(1). I get nothing.

When I do it with range, I still get a list of possible commands, but not with any other functions. I am using microsoft excel 2003 and DO have the auto-list members option checked in the options menu. Any idea why my compiler isn't auto-listing the options anymore?

Hi,

I have had this same problem a few months ago. My code even crashed on simple statements like Sheet1.Range("A1").Value = 12 (this due to the compilor not making visible the options)
Here is what I did:

-remove all modules from your workbook, and save them somewhere on your computer (right-click on a module, then select export)
-export your sheets code as well (if you have any)
-save the workbook, re-open it and goto VBE.
-here import your modules and sheet modules (File>Import File)
-if you have everything back to normal, save the workbook again.
-again re-open it, and it should work fine now.

Now if this doesn't work, try the following. Open your workbook, and goto File>Save As. Here choose the Type to Excel 97-2000 workbook.

Hope this will help
-Max