If Range ("A1) = "TEXT1" Then Range ("A2) = "TEXT 2"

I am having an issue that appears to be a simple request but I am experiencing some problems.


In short, I am trying to input text from a dropdown into a cell i.e. B3 based on the value of another dropdown in another cell i.e. B2. My current code is

HTML Code: 

Ideally, I am looking to include multiple options for the B2 value i.e. OPTION A & OPTION C, but this would still return the same value in B3 (OPTION X).

However, this errors and the Excel shuts down. I feel it should be a simple fix but cant find anything to support.

I have attached an example workbook.

The code below creates a DV list for B3 that excludes the item in F corresponding the the chosen value in B2:

Please Login or Register  to view this content.

Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code
Paste this code in the module that opens and close it.

Please Login or Register  to view this content.