Excel object browser

**guss** · 08-31-2010, 05:44 PM

In my code window the object browser tells me that Activeworkbook and Activesheet are both properties. In my code window when i type the former followed by a period '.' i get a listing of associated properties and methods I can use. But when I type the latter in the same manner I get nothing......what gives?

How can i see what properties/methods Activesheet has in the object browser?

**Mordred** · 08-31-2010, 05:57 PM

Good luck guss, I find Excel VBA to be very peculiar that way. Sometimes when I type Application. nothing happens while most of the time it gives me a list of options to choose from. I don't know why that happens.

**Paul** · 08-31-2010, 05:59 PM

Not sure how to get it to work with just Activesheet, but you could do...

Please Login or Register  to view this content.

**guss** · 08-31-2010, 06:06 PM

Aghh!

So I'm not going crazy!!

Thanks guys thought I was doing something wrong, MS sure know how to test us learners.

**Paul** · 08-31-2010, 06:13 PM

We're glad you're not going crazy (yet). Welcome to the forum!

As a plausible explanation, I found this:

ActiveSheet will not provide intellisense prompts because VBA is not
aware if the sheet im question is a work sheet, a chart sheet, a macro sheet
or a dialog sheet.

at this site: http://www.sqldrill.com/excel/progra...-text-box.html

Have a great day!

**MarvinP** · 08-31-2010, 06:16 PM

In Excel 2010 I need to click Tools -> Options -> Editor Tab -> Auto List Members. This is from the VBA Window.

In FAQs in my book it simply says "Unfortunately, Auto List Members doesn't work for all objects. So the suggestion is to type the object/word into the immediate window and press F1 for help.

I wish there was a better answer. I'll keep looking. -- Paul got there first and I like his answer.

**guss** · 08-31-2010, 06:23 PM

Originally Posted by Paul

We're glad you're not going crazy (yet). Welcome to the forum!

As a plausible explanation, I found this:

at this site: http://www.sqldrill.com/excel/progra...-text-box.html

Have a great day!

Thats a wee bit silly but I suppose thats what you gotta work with, it is surprising though!!

**shg** · 08-31-2010, 07:36 PM

Originally Posted by Mordred

Good luck guss, I find Excel VBA to be very peculiar that way. Sometimes when I type Application. nothing happens while most of the time it gives me a list of options to choose from. I don't know why that happens.

Compile your project, fix errors, and IntelliSense will return.