Now, after having learned what Excel VBA is, let’s move a bit further and see what is VB Editor.VB Editor (or more commonly known as VBE) is the tool used to create, modify and maintain Visual Basic for Applications (VBA) procedures and modules in Excel.NOTE: Many people also refer VBE as Excel IDE, IDE stands for integrated development … [Read more...]
What is Excel VBA? : Excel VBA Basics 001
Visual Basic for Applications (VBA) in Excel, is a powerful and sophisticated built-in programming language that allows you to write your own functions or commands in an Excel spreadsheet.These custom functions or commands, can help to ease your tasks and thus by using Excel VBA you can do almost any imaginable thing in Excel.Now, before we … [Read more...]
How to Merge and Combine Cells in Excel – Explained
Merging cells in a spreadsheet means taking two or more cells and constructing a single cell out of them. Merging is generally used as a cosmetic trick to center a title over a particular section in a spreadsheet.The below image clearly shows how a merged cell looks like.In this post, we will see different ways to merge cells in Excel. But … [Read more...]
VBA IF Statement – Explained With Examples
IF is one of the most popular and frequently used statements in VBA. IF statement in VBA is sometimes also called as IF THEN ELSE Statement. The task of the IF Statement is to check if a particular condition is met or not.If you have followed my earlier posts, then you would remember that we discussed If Function in Excel. The IF Function in … [Read more...]
Selecting All Checkboxes using a Single Checkbox in Excel
A few weeks ago, one of my readers left a comment on my blog asking if there is a way to select a bunch of checkboxes using a single checkbox. [Link to that comment]This is not a new issue, when you have a huge form with many checkboxes, it becomes quite cumbersome to select each checkbox individually. And this gives rise to the need of a … [Read more...]
History of Microsoft Excel 1978 – 2013 [Infographic]
How long have you been using Microsoft Excel?Have you ever thought how Excel or the other electronic spreadsheet softwares came to existence?In today’s post, we will go back in time to trace the origin of Excel. So, here we go:While the origin of electronic spreadsheets can be traced back to 1978, but it wasn’t until 1982 when Microsoft … [Read more...]
4 Easy Ways to Delete Blank Rows in Excel
Blank rows or blank cells in data sheets can be very annoying. Although deliberate inserting of empty rows can sometimes make your reports easier to read and understand.But if you are planning to import your spreadsheet to some other application (such as Microsoft Access) then these pesky blank rows make your life painful.And in this … [Read more...]
FileSystemObject in VBA – Explained
FileSystemObject also called FSO, provides an easy object-based model to access a computer’s file system. You simply have to create an instance of FileSystemObject in VBA and then you can generate files, read files, delete files, iterate through folders, and do many other operations on your computer’s file system.The FileSystemObject is present … [Read more...]
