Select Case statement Archives

Learn

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 […]

Learn

checkBox Element

The checkBox element enables users to toggle between two states. Graphical View of checkBox Attributes The following figure shows all the visible […]

IRibbonUI.InvalidateControl method Select Case statement

Learn

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. […]

Select Case statement

Learn

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 […]

Mid function Left function InStr function Trim function Val function Str function Function statement If...Then...Else statement Select Case statement Do...Loop statement

Learn

Excel Macro: Auto Save a Workbook Before Closing

This macro ensures that Excel automatically saves before closing the workbook. Get this VBA code now!

MsgBox function Workbook.BeforeClose event Workbook.Save method Select Case statement

Docs

Select Case statement

Executes one of several groups of statements, depending on the value of an expression. Syntax Select Case testexpression [ Case expressionlist-n [ […]

Select Case statement