I want the macro to let me know when there is mre than 5 and then when there is less than 5 and let me know when there is 5 Then I can add the other macros to run with the if's
Help would be greatly appreciated!Sub Macro911() If Len(A3) = 5 Then MsgBox ("You have entered 5 characters.") ElseIf Len(A3) > 5 Then MsgBox ("You have entered More than 5 characters.") ElseIf Len(A3) < 5 Then MsgBox ("You have entered 5 characters.") End If End Sub