Clever Geek Handbook

Excel VBA Combo Box returns index not value

I have a combo box in Excel 2007 that collects list items from another sheet. When I try to access the value of the selected item through a macro, all that is returned to me is the index value, not the actual value.

DateDropDown = Sheets("Input Form").Shapes("APPDateDropDown").ControlFormat.Value

The value in the combo box is listed as "Jan-12", but when running the code above, DateDropDown is returned as 37 (item index).

How can I return the value "Jan-12"?

+3


source to share


1 answer 


With Sheets("Input Form").Shapes("APPDateDropDown")
    DateDropDown = .ControlFormat.List(.ControlFormat.ListIndex)
End With


+2


source






More articles:


All Articles