Skip to main content
Excel Macro: List Files in Subfolders, Version 2
This Excel macro can list files in a specified folder and subfolders, and you can filter multiple file types. The difference from […]
checkBox Element
The checkBox element enables users to toggle between two states. Graphical View of checkBox Attributes The following figure shows all the visible […]
Using Select Case statements
Use the Select Case statement as an alternative to using ElseIf in If...Then...Else statements when comparing one expression to several different values. […]
Excel Macro: Convert Numbers Into Words
Excel does not have a default function to display numbers as English words in a worksheet, but you can do it with […]
Excel Macro: Auto Save a Workbook Before Closing
This macro ensures that Excel automatically saves before closing the workbook. Get this VBA code now!
Select Case statement
Executes one of several groups of statements, depending on the value of an expression. Syntax Select Case testexpression [ Case expressionlist-n [ […]