.listindex for list boxes. is .value the answer if yes then how ?

[ianb]

Hi,


I can update my macro to show the .listindex

I would like these to show the same values yet based upon todays dates in the formats listed below


Do it need to contain the values of now(), if yes then how is this done

also can I sent it to be -1 of todays month,etc


The formats are listed to the right of the formuals I have written.


Sheets("Sheet1").DropDowns("Drop Down 2323").ListIndex = 365 ' 24/12/2012

Sheets("Sheet1").DropDowns("Drop Down 1927").ListIndex = 24 ' Dec-12

Sheets("Sheet1").DropDowns("Drop Down 3126").ListIndex = 9 ' Q4 : 2012

Sheets("Sheet1").DropDowns("Drop Down 3209").ListIndex = 3 ' Year : 2012


Many Thanks.

 

[ianb]

Still searching for the answer if any one know how to do this. will keep you posted if I can work out the answer see previous questions as I have provided some answer to other questios around macros on listboxes and pivot tables. hope it helps people.