Results 1 to 3 of 3

Thread: Simple Class module example required
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Nov 2010
    Posts
    100
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Simple Class module example required

    Help

    Can anyone provoide me with a very simple Class module example that captures for example peoples first names in column "A", Surnames in column "B" and loops through that column and adds them to a collection.

    I think if i had a bog standard example i might actually get it! Then I can build on that.

    Many thanks

  2. #2
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    16,264
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Simple Class module example required

    An excellent tutorial
    https://excelmacromastery.com/vba-class-modules/

    For an example look at Class Module Example 1

    M.

  3. #3
    Board Regular
    Join Date
    Nov 2010
    Posts
    100
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Simple Class module example required

    Thanks Marcelo

    I actually did have a look through that site. It was helpful, but I need something shorter to start with though Simple Class module, being looped through to had the values to a collection... Or maybe it's just me

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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