how to change value of a cell based on the value selected in drop down list in excel

See more:

C#

ASP.NET

Hi All!

I have been trying to fix this issue since long but not sure what is really wrong. I need to populate a cell, say D3, with values based on the value selected in dropdown list in cell D1. I have 3 values in the dropdown- A, B, Overall. I used change event handlers, yet I do not see the values being populated. Please help. Below is the code snippet:

            xl.EnableEvents = true;
            EventDel_CellsChange = new Excel.DocEvents_ChangeEventHandler(CellsChange1);
            ws.Change += EventDel_CellsChange;

public static void CellsChange1(Excel.Range target)
    {
    if (target.Value.ToString() == "A")
        {
            xl.EnableEvents = false;
            //Do Something
            xl.EnableEvents = true;
    }
    else if (target.Value.ToString()== "B")
        {
            xl.EnableEvents = false;
            //DoSomething
            xl.EnableEvents = true;
    }
    else
        {
            xl.EnableEvents = false;
            //Do something
            xl.EnableEvents = true;
    }

This is the first time I am working on excel using c#. Please help.