Tricking Excel The Smarter Way!
IF is one of the most popular and frequently used statement in VBA. IF statement in VBA is sometimes also called as IF THEN ELSE Statement. The task of 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 Excel … [Read more...]
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...]
VBA, just like any other language gives you a set of functions to perform various operations on strings. And VBA Split is one of those string functions. Microsoft introduced Split function with VBA Version 6 (in Office 2000). As the name suggests, the job of Split statement is to break, split or divide a string based on a particular … [Read more...]
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 … [Read more...]
In my earlier post, I had written about VLookUp in Excel. It was a massive post of around 2500 words, it explains most of the things about vertical look up function in excel. Today’s post is an extension to that post and here we will understand how to apply a VLookUp in VBA. If you haven’t read that post then I would strongly recommend you … [Read more...]
Excel Text function falls under the category of String Formulas. As the name suggest the task of Text Function is to convert a numeric value to a string. This function comes quite handy when you want to display numbers in a more readable format or in such a format that makes more sense. Another situation where Text Formula can be used is : while … [Read more...]
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...]
As the name suggests SUMIF and SUMIFS formulae are formed by combining SUM and IF functions. In simple English this implies that these functions can add the items or cells that fulfill a particular criteria. Let’s understand it in detail: You know SUM function has the capability to add items, and SUMIF function extends the capabilities of … [Read more...]