If...Then...Else statement Archives

Learn

Excel Macro: Using Regular Expressions

Sometimes, Excel's built-in find-replace function doesn't meet our needs, and this time you can consider using regular expressions in Excel. To use […]

Learn

Excel Macro: Bulk Insert Pictures in Cells and Resize Them

Think you have a price list to send to your customers, you need to insert multiple product pictures in Excel, of course […]

ImageMso Office RibbonX Editor IRibbonUI.ActivateTab method LineFormat.Visible property FillFormat.UserPicture method Shapes.AddShape method IsEmpty function Shape.Name property Application.ScreenUpdating property Workbook.Path property For Each...Next statement With statement If...Then...Else statement Dir function

Learn

Using If...Then...Else statements

Use the If...Then...Else statement to run a specific statement or a block of statements, depending on the value of a condition. If...Then...Else […]

If...Then...Else statement

Learn

Excel Macro: Search on Google

If you want to use VBA to open Google Chrome and search keywords on Google, the following Macro do this. Search on […]

Shell function Shell.ShellExecute method REPLACE function InputBox function MsgBox function If...Then...Else statement Call statement Dir function

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: Limit The Number of Times a Workbook Can Be Used

Suppose you want to send a demo file for users to check, but you don't want it to be used more than […]

Workbook.FullName property Kill statement Workbook.ChangeFileAccess method DocumentProperties.Add method Choose function MsoDocProperties enumeration Workbook.CustomDocumentProperties property Workbook.BeforeSave event Workbook.RemovePersonalInformation property Workbook.Close method Workbook.Saved property Workbook.Open event Workbook.Save method With statement If...Then...Else statement On Error statement

Learn

Excel Macro: Sort Column Data By Double Clicking Header Cell

If you want to sort the column data in ascending or descending order by double clicking on any Excel column header, you […]

Range.Sort method Range.Row property Range.Count property Range.End property IsEmpty function Worksheet.BeforeDoubleClick event Exit statement If...Then...Else statement

Learn

Excel Macro: Loop Through a List of Data

When you write a VBA Macro, you may have to loop through a list of data on a worksheet, this is one of VBA's must-have skills. Get it now!

Worksheet.UsedRange property Range.Count property Range.End property Range.CurrentRegion property Font.Bold property For Each...Next statement If...Then...Else statement

Learn

Excel Macro: Zoom In and Out in Worksheet on Double-Click

Sometimes, if you want to zoom in and out in a worksheet, you need to have a finger on CTRL and the […]

Application.SendKeys method Window.Zoom property Worksheet.BeforeDoubleClick event Application.ActiveWindow property If...Then...Else statement

Learn

Excel Macro: Protect or Unprotect All Worksheets At Once

Is there any way to have a Macro protect or unprotect multiple worksheets at once in Excel quickly and easily? This Macro do this! Get it now!

InputBox function Worksheet.Unprotect method Worksheet.Protect method MsgBox function For Each...Next statement If...Then...Else statement On Error statement

Learn

Excel Macro: Group Worksheets by Color

If you assign colors to your Worksheet tabs, you may want to sort or group Worksheets based on their tab colors, this macro can help you.

Tab.ColorIndex property Worksheet.Tab property Application.ScreenUpdating property Worksheet.Move method For...Next statement If...Then...Else statement

Learn

Excel Macro: Sort Worksheets by Name

If you want to sort multiple worksheets by name, it seems very boring to do it manually. In this situations, you can use this simple macro.

UCase function Application.ScreenUpdating property Worksheet.Move method For...Next statement If...Then...Else statement