Basics of VBA / Macros Chapter – 44 (Time and Date Part-1)
Time and Date Learn how to work with dates and times in VBA. Place a command button on your worksheet and add the code lines…
Read article →Category Archives: Excel VBA
Step-by-step VBA lessons and ready-to-use macros.
Basics of VBA / Macros Chapter – 43 (String Manipulation Part-5)
Basics of VBA / Macros Chapter – 43 (String Manipulation Part-5)
Count Words Below we will look at a program in Excel VBA that counts the number of words in a selected range. One or…
Read article →Basics of VBA / Macros Chapter – 42 (String Manipulation Part-4)
Basics of VBA / Macros Chapter – 42 (String Manipulation Part-4)
Convert to Proper Case Below we will look at a program in Excel VBA that converts text to proper case. That is, the first…
Read article →Basics of VBA / Macros Chapter – 41 (String Manipulation Part-3)
Basics of VBA / Macros Chapter – 41 (String Manipulation Part-3)
Reverse Strings Below we will look at a program in Excel VBA that can reverse strings. Situation: Place a command button on your worksheet…
Read article →Basics of VBA / Macros Chapter – 40 (String Manipulation Part-2)
Basics of VBA / Macros Chapter – 40 (String Manipulation Part-2)
Separate Strings Below we will look at a program in Excel VBA that separates strings. Situation: Place a command button on your worksheet and add the…
Read article →Basics of VBA / Macros Chapter – 39 (String Manipulation Part-1)
Basics of VBA / Macros Chapter – 39 (String Manipulation Part-1)
String Manipulation In this chapter, you'll find the most important functions to manipulate strings in Excel VBA. Place a command button on your worksheet and…
Read article →Basics of VBA / Macros Chapter – 38 (Macro Comments Part-1)
Basics of VBA / Macros Chapter – 38 (Macro Comments Part-1)
Macro Comments A macro comment is a piece of text in a macro which will not be executed by Excel VBA. It is only…
Read article →Basics of VBA / Macros Chapter – 37 (Macro Errors Part-5)
Basics of VBA / Macros Chapter – 37 (Macro Errors Part-5)
Interrupt a Macro You can interrupt a macro in Excel at any time by pressing Esc or Ctrl + Break. Place a command button on…
Read article →Basics of VBA / Macros Chapter – 36 (Macro Errors Part-4)
Basics of VBA / Macros Chapter – 36 (Macro Errors Part-4)
Err Object If you are not familiar with Error Handling yet, we recommend you to read example first. When an error in Excel VBA…
Read article →Basics of VBA / Macros Chapter – 35 (Macro Errors Part-3)
Basics of VBA / Macros Chapter – 35 (Macro Errors Part-3)
Error Handling Below we will look at two programs in Excel VBA. One program simply ignores errors. The other program continues execution at a…
Read article →Basics of VBA / Macros Chapter – 34 (Macro Errors Part-2)
Basics of VBA / Macros Chapter – 34 (Macro Errors Part-2)
Debugging This example teaches you how to debug code in Excel VBA. Single Step By pressing F8, you can single step through your…
Read article →Basics of VBA / Macros Chapter – 33 (Macro Errors Part-1)
Basics of VBA / Macros Chapter – 33 (Macro Errors Part-1)
Variable/Property Not Defined Correctly This chapter teaches you how to deal with macro errors in Excel. Let's create some errors. Place a command button on…
Read article →