<div>
While in break mode, use the Locals window (from the View menu).
</div>


While in break mode, use the Locals window (from the View menu).

<div>
That shows declared variables ...<br />
It doesn't seem to allow me to browse an object<br />
or its properties.<br />
Does it? &nbsp;How would you find the name property if<br />
you didn't it even existed?<br />
<br />
Excell VB rookie<br />
Thanks<br />

</div>


That shows declared variables ...
It doesn't seem to allow me to browse an object
or its properties.
Does it?  How would you find the name property if
you didn't it even existed?

Excell VB rookie
Thanks


<div>
I'll give it shot. &nbsp;Wonder why the object<br />
browser doesn't give up the goods?
</div>


I'll give it shot.  Wonder why the object
browser doesn't give up the goods?

<div>
Object browser should show them to you but you need to know under which class it is.
</div>


Object browser should show them to you but you need to know under which class it is.

<div>
Wow, there's a mass of stuff in there!<br />
This belongs in the browser!<br />
Thanks for your help.<br />
<br />
(Now I have to figure out how to print it for reference.)
</div>


Wow, there's a mass of stuff in there!
This belongs in the browser!
Thanks for your help.

(Now I have to figure out how to print it for reference.)

<div>
I don't think that there is an easy way of printing it.
</div>


I don't think that there is an easy way of printing it.

<div>
<div class="content wysiwyg-content">
sheets has a name property. &nbsp;It is used in VBA like this:<br />
<br />
&nbsp; &nbsp; Sheets.Add<br />
&nbsp; &nbsp; Sheets(&quot;Sheet1&quot;).Select<br />
&nbsp; &nbsp; Sheets(&quot;Sheet1&quot;).Name = &quot;NewName&quot;<br />
<br />
Ok, no big deal but how would I know this? &nbsp;I go into<br />
the object browser and name is not shown as a memeber.<br />
It's subclassed from workbook(s) but I don't see <br />
how any name property I find relates.<br />
<br />
How does one investigate all the properties, like a <br />
sheets' name? &nbsp;If I hadn't seen an example, I never<br />
would have known it existed.<br />
<br />
Thanks
</div>
</div>


sheets has a name property.  It is used in VBA like this:

    Sheets.Add
    Sheets("Sheet1").Select
    Sheets("Sheet1").Name = "NewName"

Ok, no big deal but how would I know this?  I go into
the object browser and name is not shown as a memeber.
It's subclassed from workbook(s) but I don't see 
how any name property I find relates.

How does one investigate all the properties, like a 
sheets' name?  If I hadn't seen an example, I never
would have known it existed.

Thanks

excell object browser, help

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.