| HOME > RSS Feeds > - Latest Tutorial Listings For Macros | ||
| Add To: | 
|
 |
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 t...
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.
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...
Excel VBA Range
This tutorial explains the properties and methods of the very important Excel VBA Range object.
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.
Excel VBA Variable
This tutorial teaches you how to declare, initialize and display an Excel VBA variable.
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 ...
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 but...
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.
Display AutoFilter Criteria
Use a custom function to display the criteria used for any column in a table with an AutoFilter applied.