If the condition is true, the lines under the body of the If statement are executed. The ‘If statement’ is a conditional statement that consists of an expression followed by another expression. If the condition is true, the lines of code under the If statement are executed.Įnter the marks in cell A1 and click on the command button to get the result. If, If-Else, For and While Loop If statement The left keyword will extract the characters from the leftmost side of the string. This is also known as concatenation.Ĭlick on the command button to get the following result. You can join the two strings by using & operator. String manipulation refers to the process of analyzing, manipulating, and effectively handling string values. When you click on the command button, you will get the following output: Non-Numeric Data Types: Non-numeric data types consist of string, date, boolean, object, and variant.Ĭonstants are the fixed value that cannot be changed during the execution of the program.Numeric Data Types: Numeric data types consist of byte, integer, long, single, double, currency, and decimal.We can divide the VBA data types into two categories: We can change the variables during the execution of the program. Variables are the data types that are used to hold a value. Variables, Constant and Operators in VBA Variables Now when you click on the command button, you will get a prompt asking for a value.Add the following code to show the input box.

A variant variable can hold any type of value. Declare the variable name and keep the type variant.To add the InputBox to your command button, execute the following steps: The InputBox function prompts the user to enter the values and returns the information entered in the dialog box. Now, when you click on the button, you will get the following message. To create a MsgBox, add the following lines of code to the command button. The MsgBox is a dialog box in Excel that will prompt a message on your worksheet.

Visual basic for excel 2010