Subscribe
Tutorial search

Excel Macros Tutorials


We hope that you will enjoy our Excel Macros tutorials. Feel free to contact us if you would like to be a tutorial hero and contribute your own Excel Macros tutorial to our site. Thank you !

Sort by:
Macro to Remove Blank Rows
Macro to Remove Blank Rows
Great Microsoft Excel tutorial showing you how to create a macro to remove blank rows. Genius!
Difficulty:
Excel Macro
Excel Macro
Creating macros in Excel differs from one version to another. Please choose your version.
Difficulty:
Excel VBA Function and Sub
Excel VBA Function and Sub
The difference between a function and a sub in Excel VBA is that a function can return a value and a sub cannot. Functions and subs become very useful as program size increases.
Difficulty:
Excel VBA Date and Time
Excel VBA Date and Time
This chapter explains how to get the year, month and day of an Excel VBA date, how to get the number of days between two dates, how to add a number of days to a date, how to get the current date and time, how to get the hour, minute and second of the current time and how to convert a string to a time serial number.
Difficulty:
Excel VBA Loop
Excel VBA Loop
The Excel VBA Loop (or For Next loop) is a very useful programming statement which is often used in Excel VBA. First we will look at an easy example of how to loop through a one-dimensional range. You can also loop through a two-dimensional range using a Double Loop. In a similar way you can use three loops (a triple loop) to loop trough two-dimensional ranges on different Excel Worksheets. Besides For Next loops, there are other loops in Excel VBA, such as Do While Loops and For Each Next Loops.
Difficulty:
Excel VBA Array
Excel VBA Array
An Excel VBA Array is a group of variables. You can refer to a specific variable (element) of an Array by using the Array name and the index fnumber. This tutorial explains how to declare and initialize a one-dimensional and two-dimensional Array, how to Redim an Array and how to find the size of an Array.
Difficulty:
Excel VBA Range
Excel VBA Range
This tutorial explains the properties and methods of the very important Excel VBA Range object.
Difficulty:
Excel VBA Userform
Excel VBA Userform
This tutorial teaches you how to create an Excel VBA Userform (also known as a dialog box). You can download the Userform as well.
Difficulty:
Excel VBA Variable
Excel VBA Variable
This tutorial teaches you how to declare, initialize and display an Excel VBA variable.
Difficulty:
Creating Excel Custom Controls
Creating Excel Custom Controls
The rest of this tutorial takes you through the three most common control types supported by the Ribbon interface: buttons, menus, and split buttons. You'll learn the RibbonX XML code required to add and configure each control, as well as the VBA code nee
Difficulty:
Customizing the Office 2007 Ribbon
Customizing the Office 2007 Ribbon
This tutorial presents some techniques for making your macros more accessible. Learn how to enable your users to use familiar tools-namely, the Office 2007 Ribbon and its tabs, groups, and various buttons to run your macros.
Difficulty:
Prevent Case Sensitivity in VBA Code
Prevent Case Sensitivity in VBA Code
By default, Excel VBA code is case sensitive and uses what is known as binary comparisons. This means that it sees Cat and cat as two different words.
Difficulty:
Display AutoFilter Criteria
Display AutoFilter Criteria
Use a custom function to display the criteria used for any column in a table with an AutoFilter applied.
Difficulty:
Force Text to Upper- or Proper Case
Force Text to Upper- or Proper Case
Restrict all future entries in a spreadsheet or range of cells to uppercase or proper case only.
Difficulty:
Change Text to Upper- or Proper Case
Change Text to Upper- or Proper Case
When using a built-in Excel function is impractical, you can use a custom macro to change any existing text to uppercase or proper case.
Difficulty:
Total Tutorials in Category: 78