Drop Down Box.

[ianb]

'Statistics Month'!$A$2:$A$79


My Drop down box looks up mm-yyy on another sheet.


I would like to set the drop down boxes to this month. how can I do this.


At present I can only set them to a .listindex e.g.


'Set listindex to be month of today.

Sheets("Dashboard (Overview)").Select

Sheets("Dashboard (Overview)").DropDowns("Drop Down 1927").ListIndex = 25

Sheets("Dashboard (Overview)").DropDowns("Drop Down 3126").ListIndex = 11

Sheets("Dashboard (Overview)").DropDowns("Drop Down 3209").ListIndex = 5

Application.GoTo Range("a1")


I would like to have the drop down boxes be equal to this month (Now() mm-yyyy not the listindex.


Many Thanks.


Ian.

 

[Hui]

Ian


I'm not really sure what a DropDowns object is?


I assume you referring to a ComboBox object


The Format for using a Combobox is (from MS Help):

[pre]

Private Sub CommandButton1_Click()
ComboBox1.DropDown
UserForm_Initialize
End Sub

Private Sub UserForm_Initialize()
ComboBox1.Clear
ComboBox1.AddItem "Turkey"
ComboBox1.AddItem "Chicken"
ComboBox1.AddItem "Duck"
ComboBox1.AddItem "Goose"
ComboBox1.AddItem "Grouse"
End Sub

[/pre]

 

[ianb]

Thanks for the bird information and guidance. I will look into this.


many Thanks again. This is the best web site to learn excel....


Hui, JB, Colin Legg, Faseeh and NARAYANK991 with out your expertise I would have never been able to progress further. thank you for your tiem and energy in assisting me with my work project in automated dashboard and statistical data