Macro will not work if input box entry is in upper case and If statment = a item in lower cas
Is there a way to fix so macro will work regardless of how entered in input bo
Thank
Bob Leonar

Sub TestIf(

Dim varInput As Strin
Range("P5").Selec
varInput = InputBox("Enter Value"
Selection.VALUE = varInpu

If Selection.VALUE = "test_1" The
Application.Run "test

ElseIf Selection.VALUE = "test_2" Then
Application.Run "test2

End I
End Su