fbpx
Search
Close this search box.

All articles with 'macros' Tag

Announcing Online VBA Classes from Chandoo.org, Please Join Today

Published on Jan 11, 2012 in products, VBA Macros

VBA Classes from Chandoo.org - Learn Microsoft Excel VBA & MacrosFriends & Readers of Chandoo.org,

I am so happy to tell you that our VBA Classes are now open for your consideration. Click here to know more & join us.

What is this VBA Class?

VBA Class is a structured and comprehensive online training program for learning Microsoft Excel VBA (Macros). It is full of real world examples & useful theory.

The aim of VBA Classes is to make a beginner an expert in VBA.

Read on to understand the benefits of this program & how to sign-up.

Continue »

Free Picture Calendar Template – Download and make a personalized calendar today!

Published on Jan 2, 2012 in Learn Excel, VBA Macros
Free Picture Calendar Template – Download and make a personalized calendar today!

Here is something fun, personalized and delicious to start your new year. A Picture Calendar built in Excel!

Using this you can print a 12 month calendar with your own photos. Its fun to use, easy to set up and looks great. Read more to understand how this works & download the template.

Continue »

Make VBA String Comparisons Case In-sensitive [Quick Tip]

Published on Dec 1, 2011 in VBA Macros

Today, while answering a reader’s email, I wrote this VBA code, If Target.Value = “yes” Then ‘do something End If But I realized that my code would run only the Target cell has “yes” in it. It wont run if the target cell has “YES”, or “Yes” or “YeS”. This is because by default, all […]

Continue »

Excel Links – After a long time edition

Published on Oct 24, 2011 in excel links

Long time readers of Chandoo.org know that we have a regular featured called as “Excel Links“, where I share some interesting Excel articles published around the web. This used to be a weekly feature, then became a monthly thing and later once a few months thing. As I had a hectic weekend, when I got […]

Continue »

Split an Excel File in to Many using VBA [Videos]

Published on Oct 19, 2011 in VBA Macros
Split an Excel File in to Many using VBA [Videos]

Splitting an Excel file in to many is easier than splitting bill in a restaurant among friends. All you need is advanced filters, a few lines of VBA code and some data. You can go splitting in no time.

Context:

Lets say you have lots of data like this in a file. And you want to split this in to multiple files, one per salesperson.

Solution – Split Data in to Multiple Files using Advanced Filters & VBA

The process of splitting data can be broken down to 4 steps …,

Continue »

Refresh All Pivot Tables at once [Quick Tip]

Published on Sep 19, 2011 in Learn Excel, VBA Macros
Refresh All Pivot Tables at once [Quick Tip]

Pivot Tables are an integral part of Excel based reports. So it is no surprise that many of create multiple pivot reports in one Excel workbook. So when the underlying data changes, we often spend time refreshing individual pivot tables. Today, I want to share a quick tip about how to refresh all pivot tables […]

Continue »

Our VBA Class Registrations Close in Few Hours, Join Now & Learn Excel VBA

Published on Sep 16, 2011 in Training Programs, VBA Macros
Our VBA Class Registrations Close in Few Hours, Join Now & Learn Excel VBA

Hi everyone, I have a quick announcement for you.

Registrations for our VBA class will be closing in a few hours

As you may know, we have re-opened the doors for our VBA Class on September 5th. This program is aimed at beginners & intermediate level users. The aim of our VBA class is to make you awesome in Excel & VBA.

We will be closing registrations for this program in few more hours (exactly at 11:59 PM, Pacific time, on 16th September, 2011)

Click here to join our VBA Class now.

Continue »

Excel Training Recommender – Interactive Excel Tool for you

Published on Sep 12, 2011 in Learn Excel, products, VBA Macros
Excel Training Recommender – Interactive Excel Tool for you

First a Quick Announcement: Our VBA Class enrollments will be closed this Friday (Sep 16). If you want to learn VBA & Excel, please consider joining our course. More than 120 students have already joined us in the second batch and are learning VBA as you read this. Click here to learn more about the VBA Classes and join us.

Moving on…,

As you may know, Chandoo.org offers quite a few Online Excel training programs. Over the last few weeks, many of you have emailed us and asked which training program is best for your situation. This got me thinking. “It should be easy for YOU to know what is best.”

So today morning, I locked my office room and made a beautiful Excel workbook that asks you only 2 questions and tells you which training programs are best for you. Try it here.

Continue »

My Top 10 Tips for Mastering VBA & Excel Macros [Part 5 of 5 – VBA Crash Course]

Published on Sep 6, 2011 in Learn Excel, VBA Macros
My Top 10 Tips for Mastering VBA & Excel Macros [Part 5 of 5 – VBA Crash Course]

This article is part of our VBA Crash Course. Please read the rest of the articles in this series by clicking below links.

In the part 5 of our VBA Crash Course, let me share you my tips for mastering Excel VBA.

A warning before jumping in to the tips: I am not a VBA expert. I am a learner, just like you. I find VBA quite interesting language to learn and explore. These tips are based on what I have learned writing VBA (and VB code) in the last 12 years.

Continue »

Announcing Online VBA Classes from Chandoo.org, Please Join Today

Published on Sep 5, 2011 in products, VBA Macros
Announcing Online VBA Classes from Chandoo.org, Please Join Today

Dear Friends & Readers of Chandoo.org

I am happy to announce that our Online VBA Training Program is now open for your consideration. Please read this short post to understand the benefits of this program and how you can join. Click here to join our class, if you are ready.

What is this VBA Class?

VBA Class is a structured and comprehensive online training program for learning Microsoft Excel VBA (Macros). It is full of real world examples & useful theory.

The aim of VBA Classes is to make a beginner an expert in VBA.

Continue »

Putting It All Together – Our First VBA Application [Part 4 of 5 – Excel VBA Crash Course]

Published on Sep 2, 2011 in Automation, VBA Macros
Putting It All Together – Our First VBA Application [Part 4 of 5 – Excel VBA Crash Course]

In part 4 of our VBA Crash Course, we are going to create our very first VBA application using what we learned so far.

We will take the “We Are Nuts” example and create a daily sales tracker application using all the things you have learned so far. You can download the example VBA workbook and play with it to learn better.

Continue »

How to use Cells, Ranges & Other Objects in Excel VBA

Published on Aug 31, 2011 in VBA Macros
How to use Cells, Ranges & Other Objects in Excel VBA

In part 3 of our VBA Crash Course, we are going to learn how to speak with various Excel objects like Cells, Ranges etc. and deal with them.

Objects – what are they?

Any thing and everything is an object. Your dog, your bed, your neighbors cat, their car, your bike, your computer, the shiny new Excel workbook you just created, my website, your email account – every thing is an object.

From our “We are nuts” example yesterday, you can already see these objects:

One awesome owner (that is you)
24 store manager objects
24 store objects

Continue »

Understanding Variables, Conditions & Loops in VBA [Part 2 of 5]

Published on Aug 30, 2011 in VBA Macros
Understanding Variables, Conditions & Loops in VBA [Part 2 of 5]

In part 2 of our VBA Crash Course, we are going to learn what Variables, Conditions & Loops are and how to use them in Excel VBA.

What are Variables, Conditions & Loops?

If you are new to computer programming, you might think I am speaking legalese. So, to make it easy to understand, lets assume you run a bunch of stores across the town. To make it colorful, lets call your stores “We are nuts” – a dry fruit and nuts store chain. At the end of every day, you call each of the 24 store managers and ask them how much sales they have made in that day.

Now, you are not the kind of boss who micro-manages & nitpicks. So you don’t really note down sale for every store. Instead, as you call the store manager, you just mentally update the total. So first store says “$2,300” your total is 2300. Second manger says “$4,000”, the total now will be 6300. So on.

The value 6300 here is nothing but a variable.

We will use the “We are nuts” example thru out this lesson & towards the end we will build a sales logging application using Excel VBA.

Continue »

What is VBA & Writing your First VBA Macro in Excel [VBA Crash Course Part 1 of 5]

Published on Aug 29, 2011 in VBA Macros
What is VBA & Writing your First VBA Macro in Excel [VBA Crash Course Part 1 of 5]

This article is part of our VBA Crash Course. Please read the rest of the articles in this series by clicking below links.

  1. What is VBA & Writing your First VBA Macro in Excel
  2. Understanding Variables, Conditions & Loops in VBA
  3. Using Cells, Ranges & Other Objects in your Macros
  4. Putting it all together – Your First VBA Application using Excel
  5. My Top 10 Tips for Mastering VBA & Excel Macros
Continue »

Split Text on New Line using Excel & VBA [Macros]

Published on Aug 23, 2011 in Excel Howtos, VBA Macros
Split Text on New Line using Excel & VBA [Macros]

Hafiz, One of our avid readers, writes in. My problem is when I convert data from text to column using dash “-“, conversion is easy. but when the gap provided in text is with “alt+enter”, I can’t convert the data.

Well, I tried to use text to columns feature (from Data ribbon) and it would not work.

Although you can use formulas to do the splitting, they might become tedious. So the next logical option is to use macros.

In this article, learn how to use VBA to split text on New Line characters

Continue »