4 Replies Latest reply: Feb 25, 2013 9:36 AM by Chinna Reddy RSS

    Current Year and Month selection

    SIVASUBRAMANIAN KNK

      I am having two list boxes Year and month in Aging sheet. Always Current year and Current Month should get selected.

      For example, Year field has 2009,2010 and 2011,then 2011 should always get selected.

      If Year updated to 2009,2010,2011 and 2012, then 2012 should always get selected.

      Same for month.

      FYI: Only for Aging sheet, Current Year and Current Month selection should work.

      If we click the other sheets ,this Current Year and Current Month selection should not get selected.

      I am new to Macros.Please give me a clear explanation.