I am trying to convert the string "*" to the multiplication operator for an on the fly creation of a calculation. Below are the the stabs in the dark I have tried and their respective error messages reported by the compiler.
In all cases assume: Dim sMult = "*" as String
'1
iAns = (iNum1) &sMult (iNum2)
'2
iAns = iNum1 &sMult iNum2
'3
iAns = iNum1 "\sMult" iNum2
Error 1
Parsing code. Error
Error parsing program.
Error description: Use of undeclared array: smult
Occurred on line: 34
iAns = (iNum1) &sMult (iNum2)
Error 2
Parsing code. Error
Error parsing program.
Error description: Syntax error.
Occurred on line: 34
iAns = iNum1 &sMult iNum2
Error 3
Parsing code. Error
Error parsing program.
Error description: Syntax error.
Occurred on line: 35
iAns = iNum1 "\sMult" iNum2
Any help on this would be greatly appreciated. Thanks, JD