I'm trying to create a macro using the IF, THEN (or ELSEIF), based on the text in cell A5. I'm sure this is very simple, I just don't know what I'm doing.
Below is what I've tried so far and it always shows the "Else" msgbox no matter what I have in 'A5'.
Sub test() ' ' Macro11 Macro ' ' If A5 = "Everyday_Price_Rule" Then MsgBox "test1" ElseIf A5 = "Everyday_Price_Rule_Break" Then MsgBox "test2" ElseIf A5 = "Member_Price_Rule" Then MsgBox "test3" ElseIf A5 = "Member_Price_Rule_Break" Then MsgBox "test4" Else MsgBox "None selected!" End If End Sub
Bookmarks