Forcing Declaration of Variables: Option Explicit : Variable Declaration « Language Basics « VBA / Excel / Access / Word

1.	Access
2.	Application
3.	Data Type
4.	Data Type Functions
5.	Date Functions
6.	Excel
7.	File Path
8.	Forms
9.	Language Basics
10.	Math Functions
11.	Outlook
12.	PowerPoint
13.	String Functions
14.	Windows API
15.	Word
16.	XML

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

VBA / Excel / Access / Word » Language Basics » Variable Declaration

Forcing Declaration of Variables: Option Explicit

 

Option Explicit

Sub CalcCost() ' revised CalcCost procedure

    ' declaration of variables

    Dim slsPrice As Currency

    Dim slsTax As Single

    Dim cost As Currency

    Dim strMsg As String



    slsPrice = 35

    slsTax = 0.085

    cost = Format(slsPrice + (slsPrice * slsTax), "0.00")

    strMsg = "The calculator total is " & "$" & cost & "."



    MsgBox strMsg

End Sub

Related examples in the same category

1.	Declaring Variables
2.	To declare a variable in VBA use the Dim (short for Dimension) statement.
3.	Variable declaration is required with Option Explicit and a module level variable (answer) is declared.
4.	If you're going to declare multiple variables on one line, make sure each variable is specifically declared
5.	Variables can also be declared in the declarations section at the top of a module

java2s.com |

| Contact Us | Privacy Policy

All other trademarks are property of their respective owners.