Multiple Data Validation

Amirah

New Member
Joined
Aug 8, 2016
Messages
42
Hi,
What is the code to run a macro after selecting multiple of Data Validation?

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

Mel
 
Upvote 0
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.
 
Upvote 0
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]
 
Upvote 0

Forum statistics

Threads
1,226,898
Messages
6,193,563
Members
453,807
Latest member
PKruger

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top