Classes and Collections   

Could someone point me to some good tutorials on using classes and collections.
Thanks
Neal

date: Tue, 22 Jul 2008 11:04:02 -0700   author:   Neal Ostrander

Re: Classes and Collections   

Straight from F1 Access help
Repost, if you have difficulties implementing below code in yr solution.

Krgrds,
Perry

'Access Help code
'=============
Sub ClassNamer()
    Dim MyClasses As New Collection
    Dim Num
    Dim Msg As String
    Dim TheName, MyObject, NameList
    Do
        Dim Inst As New Class1
        Num = Num + 1
        Msg = "Enter a name" & Chr(13) _
         TheName = InputBox(Msg, "Name the items in the collection")
        Inst.InstanceName = TheName
        If Inst.InstanceName <> "" Then
            MyClasses.Add item := Inst, key := CStr(Num)
        End If
        Set Inst = Nothing
    Loop Until TheName = ""
    For Each MyObject In MyClasses
        NameList = NameList & MyObject.InstanceName & Chr(13)
    Next MyObject
    MsgBox NameList, , "names in collection MyClasses"

    For Num = 1 To MyClasses.Count
        MyClasses.Remove 1
    Next
End Sub




"Neal Ostrander"  schreef in 
bericht news:C3A62D9B-C06C-4054-B9EE-C595AD510B91@microsoft.com...
> Could someone point me to some good tutorials on using classes and 
> collections.
> Thanks
> Neal

date: Tue, 22 Jul 2008 21:13:12 +0200   author:   perry

Re: Classes and Collections   

Neal,
Chip Pearson has some great stuff on Classes, Collections, and
Dictionaries. He is an Excel VBA guy, but it is still very applicable
to working with these object oriented concepts. See link below:

http://www.cpearson.com/excel/topic.aspx

http://groups.google.com/group/microsoft.public.excel.programming/search?hl=en&group=microsoft.public.excel.programming&q=chipꗦꮲ觾牖겱

http://groups.google.com/group/microsoft.public.excel.programming/search?hl=en&group=microsoft.public.excel.programming&q=chipꗦꮲ觾犉敹쭢ꉻ

HTH — Lonnie M.

date: Wed, 23 Jul 2008 11:17:37 -0700 (PDT)   author:   Lonnie M.