+ Reply to Thread
Results 1 to 5 of 5

Class Modules Help

  1. #1
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Question Class Modules Help

    Hi All,

    i've reached a point where i would like to learn more about class modules but i have no resources.

    does anyone know of any sources which will help me better understand them?

    also i have a question:

    When i create a Class object can i visually see it? i want to know as i'm looking to use them within userforms if possible

    any help is really appreciated

    thanks
    Last edited by Macdave_19; 07-23-2009 at 06:45 AM.
    Mr MaGoo
    Magoo.Inc MMVII

    If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Class Modules Help

    Hello, you may start with this:
    http://www.cpearson.com/Excel/Classes.aspx

  3. #3
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Re: Class Modules Help

    Cheers I'll take a look

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,945

    Re: Class Modules Help

    the class itself is only code, no visualness.

    But within the class you can create references to objects such as userform controls, worksheet shapes, charts etc.

    I have a bunch of stuff involving classes, but unlike Chip I don't go in to detail on the basics.

    some examples.

    http://www.andypope.info/vba/Anchor.htm
    http://www.andypope.info/vba/Splitter.htm
    http://www.andypope.info/vba/userformdraw.htm
    Cheers
    Andy
    www.andypope.info

  5. #5
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Question Re: Class Modules Help

    Cheers to both you guys,

    i think i have enough to be getting on with

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1