DropDowns and item values

[gimme_this_gimme_that]

Suppose I create a dropdown as following:

Set drp = ActiveWorkbook.Sheets("Sheet1").DropDowns("GroupBy")
drp.RemoveAllItems
drp.AddItem "Group By", 232
drp.AddItem "Resource", 100
drp.AddItem "Project", 400
drp.ListIndex = 1
end Sub

If the DropDown has Project selected how do I get 400?

These return 3:

MsgBox drp.Value
MsgBox drp.ListIndex

Thanks

 

[Tom Ogilvy]

the values are not stored in the list. You would need to store them
somewhere or hard code them and figure out what the value is based on the
listindex property.

 

[gimme_this_gimme_that]

This worked:

drp.List(drp.ListIndex)

 

[Tom Ogilvy]

Not for me, not with the code you showed.

that would produce "Project", not 400.

 

[gimme_this_gimme_that]

Right.

My bad.

Thanks Tom.