-
Notifications
You must be signed in to change notification settings - Fork 0
/
ReformatMePlease.bas
50 lines (47 loc) · 1.65 KB
/
ReformatMePlease.bas
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Attribute VB_Name = "ReformatMePlease"
Option Explicit
Option Compare Text
Option Base 0
'============================================================================================================================
'
'
' Author : John Greenan
' Email :
' Company : Alignment Systems Limited
' Date : 10th September 2014
'
' Purpose : Matching Engine in Excel VBA for Alignment Systems Limited
'
' References : See VB Module FL for list extracted from VBE
' References :
'============================================================================================================================
Sub TestThisCode()
'============================================================================================================================
'
'
' Author : John Greenan
' Email :
' Company : Alignment Systems Limited
' Date : 24th March 2015
'
' Purpose : Matching Engine in Excel VBA for Alignment Systems Limited
'
' References : See VB Module FL for list extracted from VBE
' References :
'============================================================================================================================
'Constants
Const cstrMethodName As String = "ReformatMePlease.TestThisCode "
Const string1 As String = "Hello"
Const string2 As String = "world"
Const string3 As String = "!"
If Len(string2) = Len(string3) Then
If Len(string1) = Len(string3) Then
Debug.Print "blah"
Else
Debug.Print "blah blah"
End If
Debug.Print "blah blah blah"
Else
Debug.Print "blah blah blah blah"
End If
End Sub