Dear All, In Tutorial section for Beginners, I have written many basic articles like WHAT IS EXCEL MACRO, HOW TO WRITE IT, WHERE TO WRITE IT etc. As you know Errors are common while writing your code in VBA or in any other programming language for that matter. This is...
Results for "debug"
Implicit and Explicit declaration of variables in VBA
Hello friends, In the Article related to variables in VBA, I had explained following things: 1. What is Variable ? 2. Importance of Variable in Excel Programming 3. Important Rules of Variables, you must know, before declaring a Variable 4. Different Types of...
Complete Guide to Strings in Excel VBA: [Tips, Techniques, and Examples]
Strings, or text data, play a significant role in data processing and analysis in Excel VBA. Whether you're cleaning data, extracting specific information, or formatting text, mastering string manipulation techniques is essential. In this article, we'll explore...
A Complete guide to Array in Excel VBA
A complete guide to learning Array in Excel VBA programming. If you have done programming in any language C, VB, Java, Python, etc., you must have definitely heard and known of Array. The array is a data structure that stores data in a sequence. Each of its elements...
Tutorials
Connect to HP QC using Excel VBA Create Folder Structure in Test Lab and Pull test Cases from Test Plan Download Test Cases from HP QC with Design Steps Download Test Cases from HP QC without Design Steps How to connect to Access Database...
Early Binding v/s Late Binding in Excel VBA Programming
Early and Late Binding is a common phenomenon across computer programming languages. In simple terms, Binding means - how and when methods or properties of an Object are compiled and checked. In the case of Excel VBA [COM - Component Object Model] - this occurs when...
Regular Expression and its usage in Excel VBA
Dear Reders, In this article, I am going to teach you What is Regular Expression (RegExp or RegEx)? and how RegEx is used in Excel VBA programming. You will also learn the usage of Regular Expressions in Excel VBA with some example VBA code. You can also find some...
5 rarely used features in Excel VBA
Dear friends, As promised last week, in this article, I am going to talk about 5 rarely used features of Excel VBA. [I am not saying that all of these features are awesome to use... I have provided my personal choices for each of them] 1# Using IIF in Excel vba IIF is...
What is Immediate Window and how to use it in Excel VBA
Dear Friends, Have you heard of Immediate Window in Excel VBA programming? Do you know how to make use of it? If you have not been using this while doing vba programming then trust me you were missing something really cool stuff which excel provided to the...
VBA Guide to Interact with Text Files – Part – 1 of 2
ext files are one of the simplest, lightest file types. This is the reason it is highly used in programming to store a lot of configuration-related data, logs and so many other necessary data...
Buy a coffee for the author
Download FREE Tools and Templates
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
VBA: Reverse a string
It is very easy to get the Reverse of a string entered by user in Excel VBA by using VBA inbuilt functionality....
Data Anonymizer: Open Source to Anonymize Personal Data
In the ever-evolving landscape of software development, safeguarding personal data is paramount. Whether you're a...
Custom Excel Formula to Count based on Color
Dear Readers, Last Friday, my wife, Shagun Sharma, who is a Vlogger shared an excel sheet with some data and a problem...