Listbox - can you return the ItemData if you know the assoc value?

[Wrathchild]

Say I have the following values in a listbox:
ABC
BCD
CDE

Is there a way for me to supply "CDE" and get the return ItemData of 3?

I'm not looking to iterate thru the entire value list, was just wondering if there's a way to do it using the built-in listbox parameters.

thx

 

[PHV]

A starting point:
Me![list box] = "CDE"
MsgBox "ListIndex of 'CDE' is " & Me![list box].ListIndex

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Wrathchild]

Thanks PHV, but I'm trying to do this with no selection being made.

 

[Wrathchild]

I see what you're getting at now, I'm playing around with it now...