All posts by Mahmoud Mostafa

How to Use NumberFormat in VBA

Description FormatNumber is a property of the Range object of Excel. The Range object can be considered as a cell or a group of cells — be that a single cell, a column in an Excel table, or the UsedRange of an Excel sheet. The

How to Use IF OR Statements in VBA

In VBA, IF OR is the combined utilization of the IF statement and the OR keyword. Particularly, the OR keyword is used to construct the logic of the condition statement. The syntax for the combined IF OR statement is as follows: IF [condition statement 1]

The Complete Guide to Regex in VBA

Regular Expressions (Regex) are a pattern that is used to find matches within strings. This is very useful when you want to validate, replace, or extract data from strings. In Excel, regular expressions can be used when working with VBA. Matching Characters The Pattern is

The TextFrame Object in VBA with Examples

A TextFrame object is used to manipulate various elements of the text frame –basically a box of text — related to shape objects. When we have a shape object (ex. rectangle, circle, etc.), we can control the text associated with the shape through the TextFrame

How to use the RND Function in VBA

Introduction The RND function is used to generate a random number between 0 and 1. Generating a random number has applications in domains such as gambling, statistical sampling, computer simulation, or to — generally speaking — create unpredictable results for any other purpose. Of course,

How to Use CountIf in VBA

In Excel, the function CountIf is used to count how many times a condition has been met within a worksheet range. However, to use this function while writing VBA code, we need to change it from CountIf to WorksheetFunction.CountIf. The full syntax of the function

scraping from wikipedia

GetElementById in VBA

Visual Basic for Applications allows you to get data and information from websites. This is called ‘web scraping’. Web pages are written in a markup language called HTML. Anything that interests you in a webpage can be retrieved once we know which HTML element it

else without if error popup

Else Without If Error in VBA: Why Is it Happening?

What you’re seeing is a compile error that indicates that an Else (or ElseIf) keyword was not preceded by a correct If statement. Meaning, the compiler found an Else statement (which it will highlight for the user) without seeing an If statement in the lines