Folks,
I am having a problem with the syntax in line 8 and need help here please
Sub UserInput() Dim Results As Variant Results = Range("L9").Value If Not (IsNumeric(Results)) Then 'not a number MsgBox "Invalid value for Significance – must be numeric!", vbCritical Range("L9").ClearContents Range("L9").Select ElseIf Results = "<=0" or Results "=>1" Then 'The value must be great than 0 and less than 1 MsgBox "Invalid value for Significance - must not be greater than zero but less than 1!", vbCritical Range("L9").ClearContents Range("L9").Select End IfEnd Sub