Results 1 to 14 of 14
  1. #1
    New Lounger
    Join Date
    Oct 2014
    Posts
    6
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Learning to write macros

    Where is the best place to learn to write and understand macros and macro coding? Is there a really good website or video out there? thank you

  2. #2
    3 Star Lounger
    Join Date
    Nov 2011
    Location
    Australia
    Posts
    221
    Thanks
    80
    Thanked 3 Times in 2 Posts

    Exclamation

    I was shown Record Macro in Excel in 1995, the things I did repetitively, mainly some book keeping for work-at-home budgets. I needed repetitive accuracy.

    Then Recorded a simple formula from one cell rang to another.

    Opened the VBA editor and looked at the recorded code, Pressed F8 to see it work and what it meant.
    Trial and Error.

    Always Save what you Solve as you go, learnt that one the hard way.

    Asked A LOT of questions here and great help.
    Eventually something sinks in, but there is always so much more, a new twist or someone elses spin on coding.

    Read threads and try a few samples, that helps to.

  3. The Following User Says Thank You to XPDiHard For This Useful Post:

    hescobe (2014-10-10)

  4. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi

    I found one of the best ways to learn macros was to look at macros that had been done by others ahead of me.

    I still find this a useful method.

    zeddy

  5. The Following User Says Thank You to zeddy For This Useful Post:

    hescobe (2014-10-10)

  6. #4
    New Lounger
    Join Date
    Oct 2014
    Posts
    6
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Thank y'all!!

  7. #5
    New Lounger
    Join Date
    Oct 2014
    Posts
    6
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Thanks for great ideas!!

  8. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    You can check this out if you like
    Attached Files Attached Files

  9. The Following 6 Users Say Thank You to Maudibe For This Useful Post:

    Alouso (2014-10-10),cmptrgy (2014-10-11),Derfacnauck (2014-10-28),Herman Escobedo (2014-10-26),hescobe (2014-10-11),mrjimphelps (2014-10-22)

  10. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Maudibe...nice work!!

  11. The Following User Says Thank You to kweaver For This Useful Post:

    Maudibe (2014-10-10)

  12. #8
    New Lounger
    Join Date
    Dec 2013
    Posts
    22
    Thanks
    2
    Thanked 6 Times in 6 Posts
    I learned from an excellent book, Excel 2002 Power Programming by John Walkenbach. He releases a new edition for each version of Excel—the latest is Excel 2013. I imagine there are only minor changes each time.

  13. The Following User Says Thank You to THill For This Useful Post:

    Herman Escobedo (2014-10-26)

  14. #9
    Star Lounger
    Join Date
    May 2013
    Posts
    59
    Thanks
    34
    Thanked 6 Times in 6 Posts
    Phenomenal Maudibe!!!

  15. The Following User Says Thank You to Alouso For This Useful Post:

    Maudibe (2014-10-11)

  16. #10
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    Also see THIS THREAD, which asks and answers a similar question.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  17. #11
    WS Lounge VIP mrjimphelps's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    3,405
    Thanks
    447
    Thanked 404 Times in 376 Posts
    Excellent, Maudibe!

  18. The Following User Says Thank You to mrjimphelps For This Useful Post:

    Maudibe (2014-10-22)

  19. #12
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    Maudibe - You can make a good piece even better by explaining about the Forms Controls, or including a reference to someplace where they are explained. As I recall, they are easy to use, less flexible than the other kind, and hard to find explanations of.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  20. The Following User Says Thank You to Lou Sander For This Useful Post:

    Maudibe (2014-10-25)

  21. #13
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Lou,

    Since Form controls are not active X controls and cannot encapsulate VBA code, they were outside the scope of this topic. See the following link

    http://support.microsoft.com/kb/291073

  22. #14
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    Thinking it through some more... from what I know, which is far from expertise...

    The button is the most widely used Form control by far. You can use it to run a macro, but that's about all. That is its big disadvantage: only does one thing.

    Its big advantage is that it's easy to use. You don't need to know anything about VBA, etc. All you need to know is how to create the button (differently from creating an Active X button), how to put text on it, how to resize it, and how to make it move or not move with its associated cells.

    If you know how to record macros, you need to know about that button.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

Tags for this Thread

Posting Permissions

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