Re: run macro after data validation
i've tried this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B26")) Is Nothing Then
Select Case Target.Text
.Value = "It is the " & Target.Value & " foreign exchange rate which is defined as how many Malaysian Ringgit (MYR) per 1 US Dollars (USD) as determined by the Calculation agent in its sole capacity."
.Characters(11, 7).Font.ColorIndex = 44
.Characters(70, 23).Font.ColorIndex = 3
.Characters(100, 16).Font.ColorIndex = 29
The code is just cater for USD/MYR .I'll do for the rest currencies when it is fine. So, here is my problem, When I execute this code, the output doesn't came out. It seems the code is not running.
I need to create a code based on data validation . Say that user select the currencypair (USD/MYR,USD/EUR,USD/GBP, MYR/GBP, GBP/EUR)
and I need to display this output :
It is the USD/MYR foreign exchange rate which is defined as how many Malaysian Ringgit (MYR) per 1 US Dollars (USD) as determined by the Calculation agent in its sole capacity.
the colored words will be changed based on the input selected.
The data validation selection will be in cell A26 at PRODUCT page whilst the written code will displaying the output in cell B39 at TERMSHEET page.
I need help [Blocked Image: http://www.mrexcel.com/forum/images/smilies/icon_smile.gif]