Posts by Amirah

  • run macro after data validation

    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
    With Worksheets("TERMSHEET").Range("B39").Value
    Select Case Target.Text
    Case "USD/MYR"
    .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


    End Select
    End With
    End If
    End Sub




    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.


    Thanks

  • run macro after data validation

    Hi,


    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]



    Thanks,
    Mira