The psychology of writing macros


In this Excel Macro Writing email course you will know my most guarded macro writing secrets that will empower you write the macros you dream to beat the application and the boss and use your legitimately-gained free time on what matters to you the most (more work, family, cooking, your dog, reading, etc).

In the previous lesson, we learned that…

…for breaking the chains of work, knowing Excel VBA is not enough. You need to actually write the damn Excel macros. The dilemma of macros is that you can end up being busy trying to get you out of busyness because writing macros requires time and effort (and skill).

Excel macros are extremely powerful but first, you must get the macros done.

But many professionals reject this smart kind of busyness. They prefer being busy on what will keep them busy, and they end up a forever slave of work.

You are reading this because you know that’s not a wise choice.

One MUST be busy on being unbusy…

…but not everyone is prepared to endure the macros journey to freedom :(

The technical and psychological problems of developing your own macros are just way too many…

  • The macro is too long
  • The macro does not work and you can’t find the source of error
  • The macro cannot be used in different situations
  • The macro will take time and effort to complete
  • The macro is becoming too complex
  • You forgot the purpose of the code you wrote
  • You don’t know how to get started writing a macro

Some of these macro conditions are avoidable while others should be managed.

If you want to win the game of writing macros, you’ve got to develop what I call…

The psychology of writing Excel macros

Writing macros is no a sprint but a marathon. You never are in a rush. You are never disappointed if you have not reached your destination yet because you know you are in the middle of a journey and you are always on the right path.

If you keep a consistent structure across your macros, as in a novel, the title, subtitle, intro, chapter 1, chapter 2, outro, etc., you can act at every step with total ease and intensity.

This is the secret way others develop proficiency writing macros and amass a library of operational macros they can use every day or carry from project to project, from work to work.

New VBA and life creative possibilities

Once you develop the macro mindset and add structure to your macros, you will be able to make miracles!

  • Sit and start making progress on your macro
  • Find a place for every new macro idea that comes to your mind
  • Accomplish bigger projects because if you break your macros down into sections, you focus on one aspect at a time and so you are never overwhelmed by complexity
  • Never again put a macro in the category of “abandoned macros” because you clearly identify the lines or sections of your macro that need more attention

If you become able to create operational Excel macros consistently, your life will never be the same again because you will get rid of the tasks that consume time. You will have plenty of free time to use or enjoy the way you and your loved ones like!

In the next lesson, I will reveal a magical way to add structure to your macros so the VBA code almost writes itself. Once your macros have this structure in place, version control, debugging, and expanding your macros get a lot easier!

Stay tuned!


John Franco

Next masterclass: The 5 building blocks of an operational macro

What’s your current writing Excel macros strategy and why it works/fails? Join the conversation below…

14 comments… add one
  • TP Redkar

    I’m eagerly waiting for forthcoming chapter. Many Thanks.

  • Katy

    Would love to learn more! I am new to the work of macro’s but can see a huge benefit in many ways. =)

  • Bob Kaplan

    I find it very frustrating to share .XLSM files with co-workers who are not familiar with how to change their macro security settings. AND, are then fearful when you tell them it’s ok to choose a setting that Microsoft shows as “not recommended”.
    I wish there were a way to send an XLSM file to a non-user of macros without having to go through all the issues mentioned above.


  • Geoff Baldwin

    Thanks John,
    I have been using time saving macros for years and believe that all excel users should get the same benefit,
    Am looking forward to your next lesson,
    Kind Regards

  • Louis Jaramillo

    Looking forward to the tips

  • Sulbell

    Macros are interesting, but are very annoying when you end up not getting the desired result. I keep my finger crossed awaiting the next lesson. Kudos John.

  • Tudor Williams

    I have always found when writing any code, that time spent on being very sure about what I am are trying to achieve and the steps needed to be taken is far longer than I have taken!
    By that I mean most of us are in a rush to complete the macro and consequently overlook some aspect or other. Very annoying as it means that you have then to do extra work.
    Far better to write some pseudo code and keep a check on all the steps needed, plus – do not forget to add meaningful comments .

    • John Franco

      Thanks for your insights Tudor!
      You are so right. An OPERATIONAL macro does not neccesarily take that extra work of a PERFECT macro. If the code works, keep it. There’s always room for improvement (make the code shorter, more dynamic, etc.)

  • Loretta Little

    You give me the impression that writing usable macros are not as difficult as we make it. I’m anxious to learn more about the basic principles.

    • John Franco

      Exactly Loretta!!!
      We tend to make things (macros) more complicated than they need to be :)
      I used to abandon all the Excel macros I started :(
      We find macros difficult to complete partly because we start writing a macro without a clear goal of what the macro should accomplish. Many just don’t now what’s the exact output they want out of the damn Excel VBA code.
      We tend to forget the simple fact that macros should operational not just technical.
      In the next lesson, you will learn to define the exact output of your macro and discover how the rest will fall naturally into place.

  • Laura Samuelson

    Interesting letter….great sounding ideas… can’t wait to see what is next!

    • John Franco

      Thanks for your feedback Laura!!
      See you on the next Excel macro writing lesson.


    I look forward to you next class. Thank you for making my life easier.

    • John Franco

      Thanks Larry!

      I am eager to disclose my most guarded Excel VBA writing techniques. Once you realize some few macro writing principles, your life will be never be the same because you will get the damn macros done (at the operational level or beyond) and have more time. And Freedom is the most precious thing!

      Stay tuned!

Leave a Comment