|
Subject:
|
Listing members
|
|
Posted By:
|
quiksilverhg
|
Post Date:
|
9/30/2005 11:12:10 AM
|
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?
|
|
Reply By:
|
maxpotters
|
Reply Date:
|
10/6/2005 5:09:48 AM
|
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
|
|
