Current Year and Month selection

[siva0606]

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.

[sushil353]

hi,

PFA

I have added trigger on sheet level.

Check trigger in

Settings>sheet level properties>trigger

HTH

Sushil

[siva0606]

Thanks

[sushil353]

Hi Siva,

if your problem is resolved then please close this thread marking this as answered.

HTH

Sushil

[#5]

I am using the same thing in version 11 but it is good gor year but when i select it for month the changes are being made in two sheets