General Format of Thesis Journal
Essential Elements of VBA
Language
Using Comments in VBA Code
Using Assignment Statements
Sub FormatCells()
‘ Exit if a range is not selected
If TypeName(Selection) “Range” Then
MsgBox “Select a range.”
Exit Sub
End If
‘ Format the cells
With Selection
.HorizontalAlignment = xlRight
.WrapText = False ‘ no wrap
.MergeCells = False ‘ no merged cells
End With
End Sub
Using Variables, Constants, and
Data Types
Since VBA is a real, live programming language, it utilizes various elements common to all programming languages. Comment is the simplest type of VBA statement. Apostrophe (‘) is used to start a comment. Comments can be inserted at the end of a line of code or you use the entire line for your comment. See example below:
Arrays
*Property of STI
I0033
1 __________________________ 2 _________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
VBA does not interpret an apostrophe inside a set of quotation marks as a comment indicator. The example below illustrates this condition, though there is an apostrophe:
Edit Toolbar under the View Menu
Msg = “Can’t continue”
VBA will ignore statements starting with apostrophes when a routine is executed. Simply remove the apostrophes to make those statements active again. The quick way to convert a series of statements to comments in VBE is to select View > Toolbars > Edit to show the Edit Toolbar. Select the statements and click the
Comment Block button to convert the series of statements into comments. Select the statements
Language
Using Comments in VBA Code
Using Assignment Statements
Sub FormatCells()
‘ Exit if a range is not selected
If TypeName(Selection) “Range” Then
MsgBox “Select a range.”
Exit Sub
End If
‘ Format the cells
With Selection
.HorizontalAlignment = xlRight
.WrapText = False ‘ no wrap
.MergeCells = False ‘ no merged cells
End With
End Sub
Using Variables, Constants, and
Data Types
Since VBA is a real, live programming language, it utilizes various elements common to all programming languages. Comment is the simplest type of VBA statement. Apostrophe (‘) is used to start a comment. Comments can be inserted at the end of a line of code or you use the entire line for your comment. See example below:
Arrays
*Property of STI
I0033
1 __________________________ 2 _________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
VBA does not interpret an apostrophe inside a set of quotation marks as a comment indicator. The example below illustrates this condition, though there is an apostrophe:
Edit Toolbar under the View Menu
Msg = “Can’t continue”
VBA will ignore statements starting with apostrophes when a routine is executed. Simply remove the apostrophes to make those statements active again. The quick way to convert a series of statements to comments in VBE is to select View > Toolbars > Edit to show the Edit Toolbar. Select the statements and click the
Comment Block button to convert the series of statements into comments. Select the statements