Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Class help (Excel 2003)

    Hi all,

    I have been trying out some examples on the net that I had found, and I hvae a question regarding this one example regarding a class module, I have been able to figure out the label control as a class, and a commandbutton as a class, but what I cna't figure out is why I can't read the comboboxs on Userform1? The Error I get is, "Expected Array, can someone tell me why it the compiler doesn't see the combobox's?

    Thanks,
    Darryl.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Class help (Excel 2003)

    ReDim expects an array variable, but you haven't declared Combo as an array variable. The () in your declaration

    Dim buttons() As New Class1

    specify buttons as an array. Similarly, you should use

    Dim Combo() As New Class2

  3. #3
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Class help (Excel 2003)

    Thanks Hans.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •