Microsoft Excel 5E: If Then Statements and Input Boxes in Macro Programming Modules

If Then Statements:

• These are used all the time in all computer programs.
• Example:

If car=red then

out_of_stock

EndIf

• In the example above if a car is red then a macro named "out_of_stock" is executed, presumably explaining that the car is out of stock and asking to select anothe colour.

Input Boxes:

• You see these all the times in computer programs, like those pop-up boxes asking for your password, name etc.

Loops:

• Loops can be combined with if then statements and input boxes

This website is copyright protected see contact page for details.