Validate variable from InputBox is either "A" or "B"

[jardenp]

I am using an InputBox to ask for variable AcctSelect. I want to set up a simple If Then statement to test if AcctSelect is either 1) "A" or "B" or 2) something else and then exit sub. I need to use the variable later for column selection and anything other than "a" or "b" would throw an error. Case is not important. Something like this, with the red parts replaced by actual code that does what's described:

dim AcctSelect as String
AcctSelect =  InputBox("Enter A or B")

IF [COLOR=#ff0000](AcctSelect = "A" OR AcctSelect = "B") [/COLOR]Then[INDENT]Range("A1").Select[/INDENT]
Else 
[INDENT]MsgBox "Please rerun macro and enter ""A"" or ""B"""
Exit Sub[/INDENT]
End If

Also, I know I could loop it back to the InputBox, but I'd like it to exit the sub if it's neither "A" nor "B" (again, if it matters, it's not case-sensitive).

Thanks!

Josh in IN

 

[Dryver14]

Have you put brackets around this for our benefit or are they really there? if so remove them

 

[WarPigl3t]

You want us here in the forums to fix the red text by turning it into "Actual code". That is what I think you are asking. The problem is that it is actual code. Nothing needs to get fixed. You did it all by yourself. gj

 

[jardenp]

Wow. Yeah, I was just trying to communicate what I wanted and that's the code (minus brackets)? That's never happened. Thanks, Dryver14 and WarPigl3t! I must be a natural!