How to lookup VBA Dictionary key

[may1hem]

I'm familiar with defining a Dictionary object and storing pairs of values, e.g.
ProductCode234, Bread
ProductCode546, Milk
ProductCode812, Tea

I know that if I want the value of product code 234 I use dictionary.item("ProductCode234") to retrieve the value "Bread".

But how can I lookup "Bread" to retrieve the product code? Is this possible without using a for..each loop?

Thanks,
May

 

[combo]

The key has to be unique, item text - no. So there is no direct way to get the key for given item. For 1:1 relation (key - value) you could consider second dictionary (or array for code numbers within reasonable range).

combo

 

[white605]

May,
If you are using the Dictionary object of VB Scripting, I was reading (

http://franca.exofire.net/jq/vba_dictionary)

and it is refering to the key value as:

'This is how you iterate through the dictionary object and 'print all the key and item pairs:

Dim key As Variant
For Each key In dic.Keys
Debug.Print CStr(key) & " - " & dic.Item(key)
Next

This old world keeps spinning round - It's a wonder tall trees ain't layin' down