title: Macro code based on multiple data validation?
body: <p>How do I create macro code whereby the user needs to select a few of the input (data validation) and it will produce different result? In my case, the input are in PRODUCT page and consists of:</p>
  
  <ul>
  <li>product's name</li>
  <li>currency pair</li>
  <li>leverage</li>
  <li>bank</li>
  </ul>
  
  <p>so, the outcome has to come out at TERMSHEET page.</p>
  
  <p>My idea is to use Select case within Select case, but it doesn't work.  </p>
  
  <p>My code:</p>
  
  <pre><code>With Worksheets("TERMSHEET")
     Select Case Target.text
  
          Case "Anytime Knock-In"
  
              Select Case Target.text
              Case "BUY"
  
                  Select Case Target.text
                  Case "YES"
                  .Range("A7").Value = "This USD/MYR Anytime Knock-In Forward transaction allows client to protect against USD"
                  .Range("A8").Value = "strengtening from the Strike Ratewhilst getting limited participation to USD weakening"
                  .Range("A9").Value = "until Knock-In Barrier (which is monitored all the times is triggered. Once the Knock-In"
                  .Range("A10").Value = "Barrier is triggerd, this structure will behave like a normal Formal contract and client"
                  .Range("A11").Value = "no longer gets to participate to a weaker USD"
  
                  End Select
  
              End Select
  
      End Select
  
  End With
  </code></pre>
  
  <p>The input comes from the following <code>Cells</code>:</p>
  
  <ul>
  <li>"Anytime Knock-In" is in <code>Cell B9</code></li>
  <li>"BUY" is in <code>Cell B19</code></li>
  <li>"YES" is in <code>Cell B27</code></li>
  <li>"USD/MYR" is in <code>Cell B25</code></li>
  </ul>