Auto list members

[Michael Singmin]

Hello Group,

Programming in VBA, the autolist members option is extremely useful
and instructive.

I have never seen any documentation of the members that appear ?
Can one access these lists in any way ?

Thanks,

Michael Singmin

 

[Jim Rech]

When you type "Range." in a module you get a list that starts with Activate.
If you open the Object Browser (shortcut = F2) and select Range in the left
list box you get the same list starting with Activate in the right list box.
Is that what you meant?

--
Jim Rech
Excel MVP
| Hello Group,
|
| Programming in VBA, the autolist members option is extremely useful
| and instructive.
|
| I have never seen any documentation of the members that appear ?
| Can one access these lists in any way ?
|
| Thanks,
|
| Michael Singmin

 

[Michael Singmin]

Hello Jim,

Thank you for that suggestion.
Since I started learning Excel VBA in 2001, I have pressed F2 in the
VBE many times (by accident) and wondered what all this code was.
Now I am informed.

Thanks,

Michael
=================================================================