2 Replies Latest reply: Jan 31, 2012 5:39 AM by Paul Damen RSS

    Selecting all months to date when activating a worksheet

    Paul Damen

      Hi all,

       

      This is probably a question with an easy answer but I can't get it to work. When I activate a worksheet all months to date should be selected in the month listbox (so today that would only be January, tomorrow January and February).

      I tried everything with the triggers but I can only manage to select 1 item in the listbox (f.e I also have a year listbox where it should select current year, I solved that one with: =Year(Today('YYYY')), this gives me the current year).

       

      But I can't get it to work to select multiple months. Can someone help?

       

      Regards,

       

      Paul