Multiple Data Validation

[Amirah]

Hi,
What is the code to run a macro after selecting multiple of Data Validation?

Thanks

 

[Mel Smith]

You need to provide more detail and ideally a sample of data and expected/required outcomes.

Mel

 

[Amirah]

Hi,
I've write the code to be like this:


If Not Intersect(target, Range("B9", "B18", "B20", "B26", "B30", "B32")) Is Nothing Then




If target.Value = "Anytime Knock-In" & "BUY" Then

If Len(target.Value) > 2 Then Worksheets("TERMSHEET").Range("A51").Value = Worksheets("PRODUCT").Range("A38").Value
If Len(target.Value) > 2 Then Worksheets("TERMSHEET").Range("B51").Value = Worksheets("PRODUCT").Range("B38").Value

If Len(target.Value) > 2 Then Worksheets("TERMSHEET").Range("A53").Value = Worksheets("PRODUCT").Range("C9").Value
If Len(target.Value) > 2 Then Worksheets("TERMSHEET").Range("B53").Value = Worksheets("PRODUCT").Range("D9").Value

If Len(target.Value) > 2 Then Worksheets("TERMSHEET").Range("A55").Value = "Anytime Knock-In Event:"
If Len(target.Value) > 2 Then Worksheets("TERMSHEET").Range("B55").Value = "An Anytime Knock-In event is deemed to have occured when the Reference Currency Rate is deemed to have"
If Len(target.Value) > 2 Then Worksheets("TERMSHEET").Range("B56").Value = "traded to at or below the Anytime Knock-In Rate"


End If

and I got compile error. I bet there is something wrong with the colored code.

 

[Amirah]

hi,

Here is the details:

the user needs to select certain input from data validation in the input pages such as:
[TABLE="width: 182"]
<colgroup><col></colgroup><tbody>[TR]
[TD]PRODUCT [/TD]
[/TR]
[TR]
[TD]Anytime Knock-In [/TD]
[/TR]
[TR]
[TD]Anytime Knock-Out [/TD]
[/TR]
[TR]
[TD]Collar[/TD]
[/TR]
[TR]
[TD]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 156"]
<colgroup><col></colgroup><tbody>[TR]
[TD]BANK[/TD]
[/TR]
[TR]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]SELL

[TABLE="width: 183"]
<colgroup><col></colgroup><tbody>[TR]
[TD]CURRENCY[/TD]
[/TR]
[TR]
[TD]USD/MYR[/TD]
[/TR]
[TR]
[TD]USD/EUR[/TD]
[/TR]
[TR]
[TD]USD/GBP[/TD]
[/TR]
[TR]
[TD]USD/AUD

LEVERAGE
[TABLE="width: 95"]
<colgroup><col></colgroup><tbody>[TR]
[TD]NO [/TD]
[/TR]
[TR]
[TD]YES[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 182"]
<colgroup><col></colgroup><tbody>[TR]
[TD]So, the colored words is the input that need to be select.

if the user select all the inputs, certain output will be come out. [/TD]
[/TR]
[TR]
[TD]
Say this is the example of output:

This USD/MYR Anytime Knockin Forward transaction allows client to protect against USD strengthening from the Strike Rate whilst getting limited participation to USD weakening until the Knockin Barrier (which is monitored at all times) is triggered. Once the Knockin Barrier is triggered, this structure will behave like a normal Forward contract and client no longer gets to participate to a weaker USD.
The client is willing to accept a Strike Rate worse than the Par Forward Rate prevailing at trade date and time but gets to secure his worst possible hedge rate at trade inception whilst getting limited participation to a weaker USD.
[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]and there are a lot of output. So, I was thinking to combine all the input in the code. So that all the output will be come out

Do you understand it?

Many thanks[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]