Call Sub dependant on Cell Value

[grady121]

I have a userform with a Cmd button, when clicked I want it to call one of two Subs, depending on the value of Cell "A1".
At the moment it all works OK apart from the fact that If Range("A1") = "P" - its calling Code2. i.e. the wrong Sub ???
How do I reference "P" correctly?


If Range("A1") = "P" Then Call Code1
If Range("A1") <= "4" Then Call Code1

If Range("A1") >= "5" Then Call Code2


Any help to a Newbie appreciated.

 

[Fowmy]

Assuming Range("A1") has either 4,5, or "P" - Try this

If Range("A1") = "P" Or Range("A1") <= 4 Then
Call code1
ElseIf Range("a1") >= 5 Then
Call code2
End If

 

[grady121]

Thanks Fowmy
Just what I needed.
I tried every which way but it seems I just "Couldn't see the Woods from the Tree's" - again.

Thanks for quick response.