Home » If...Then...Else statement
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 […]
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
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 […]
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 […]
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: 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
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 […]
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!
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 […]
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!
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.
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.