D
Dennis
Just beginning my foray into VBA.
Attempting the following:
Error message Compile error: Sub or function not defined
Upper() is highlighted in blue
Sub GetMyView()
Dim MyView As String
Do Until upper(MyView) = "[ALL]" Or upper(MyView) = _
"[CMI]" Or upper(MyView) = "[XL]"
MyView = InputBox("Enter CMI or XL or ALL", "Enter Desired View")
Loop
End Sub
in John Walkenbach's VBA 2003 programming book (Page 364) the only use of Excel's
UPPER() function showed this string technique used above "[ALL]".
What is the purpose of "[xxxx]" vs.. "xxxx"?
Is the Upper functions supported in VBA? If so, any syntax differences vs. Excel?
TIA Dennis
Attempting the following:
Error message Compile error: Sub or function not defined
Upper() is highlighted in blue
Sub GetMyView()
Dim MyView As String
Do Until upper(MyView) = "[ALL]" Or upper(MyView) = _
"[CMI]" Or upper(MyView) = "[XL]"
MyView = InputBox("Enter CMI or XL or ALL", "Enter Desired View")
Loop
End Sub
in John Walkenbach's VBA 2003 programming book (Page 364) the only use of Excel's
UPPER() function showed this string technique used above "[ALL]".
What is the purpose of "[xxxx]" vs.. "xxxx"?
Is the Upper functions supported in VBA? If so, any syntax differences vs. Excel?
TIA Dennis