Referencing form tools

[Jamesm601]

Hi All
In the project I'm developing, I've been making liberal use of this command "ActiveSheet.CheckBoxes(i)" to reference objects in the checkbox collection within looping constructs. I've even figured out how to assign these objects to collections of my own making:
____
Dim checkboxcoll As New Collection
checkboxcoll.Add (ActiveSheet.CheckBoxes(1))
____

What I need to know is how to do this with other objects such as command buttons, option buttons, etc. I know this is a pretty basic question. I'm just new to this, and don't have access to a reference to all objects, methods, properties, etc in VBA. (My VBA help file was never installed) Rather than answering my question directly, if anyone knows of an exhaustive online reference of this type, that would be a life-saver.

Thanks in advance.

James M.

 

[steveouthwaite]

The best reference is microsoft ...

http://msdn.microsoft.com/

you should be able to add any control to a collection as you have done above.


SteveO

 

[PHV]

And what about installing the VBA help files from your office CD ?

 

[Jamesm601]

I'll check the Microsoft site. As for the CD, that's the first place I went, but I'm doing this at work, and it's not available for some reason. I guess what I'm wondering is if these objects are assigned to a collection by default, so I can reference them indirectly in a for loop to assign them to my own collection. I apologize for the pedestrian nature of my question. I normally work in Mumps, and am something of a VBA newbie.

Thanks for the help.