Try the dictionary from the scripting runtime library.

Tim

"fazstp" wrote in message
...

Is there a property list type in vba? I have codes in a table that I
would like to match to a description.

ie:
If column A contained the type code and I wanted the description in
column B

Descriptions = ["1C": "Designer Ace C", "1D": "Designer Ace D"...]
Range("B2").Value = Descriptions[Range("A2").Value]


--
fazstp
------------------------------------------------------------------------
fazstp's Profile: http://www.excelforum.com/member.php...o&userid=30574
View this thread: http://www.excelforum.com/showthread...hreadid=547677