lexluther88
11-10-2006, 09:01 PM
I'm trying to make a message box appear that says
title "Wrong Magic Words" and message "<words> are not the magic words." where <words> is actually what the user typed in. (Hint: You'll need to concatenate a variable with a string.)
I defined what the user typed in as the magic words as the following:
Const strMAGICCODE = "Trick Or Treat"
Dim strMAGICDODE As String
Dim strCODESTORAGE As String
strCODESTORAGE = InputBox("Enter the magic words", "User Validation")
If strMAGICCODE = strCODESTORAGE Then
ToggleButtons True
Else
MsgBox = Concat("strCODESTORAGE" & "Are not the magic words"), vbOKOnly, "Wrong Magic Words"
End If
..I get an error though in the Concat section saying that a sub or function isn't defined..
am I supposed to use strMAGICCODE..or strCODESTORAGE? Or am I supposed to set another variable or maybe a cell to hold the value that the user types in?
please help
title "Wrong Magic Words" and message "<words> are not the magic words." where <words> is actually what the user typed in. (Hint: You'll need to concatenate a variable with a string.)
I defined what the user typed in as the magic words as the following:
Const strMAGICCODE = "Trick Or Treat"
Dim strMAGICDODE As String
Dim strCODESTORAGE As String
strCODESTORAGE = InputBox("Enter the magic words", "User Validation")
If strMAGICCODE = strCODESTORAGE Then
ToggleButtons True
Else
MsgBox = Concat("strCODESTORAGE" & "Are not the magic words"), vbOKOnly, "Wrong Magic Words"
End If
..I get an error though in the Concat section saying that a sub or function isn't defined..
am I supposed to use strMAGICCODE..or strCODESTORAGE? Or am I supposed to set another variable or maybe a cell to hold the value that the user types in?
please help