Dictionary key made up of multiple values/criteria?

[ColdDay]

Can an Excel VBA dictionary key be made up of multiple values?

If I have 4 columns of data: (A) Number, (B) Job, (C) Date and (D) Hours, can I combine the values of A, B and C to create the key and then return the value of D?

1000 6666 01/01/1999 1.00
1000 6666 02/02/1999 2.00
1000 6666 03/03/1999 3.00


To retrieve the hours of 1.00, is it possible to combine "1000" and "6666" and "01/01/1999" to make the key?

To retrieve the hours of 2.00, is it possible to combine "1000" and "6666" and "02/02/1999" to make the key?

If possible, what would be the syntax ?

Thanks.

Bill

[abousetta]

Please Login or Register  to view this content.

[LJMetzger]

Hi ColdDay,

Excellent question. What I like to do is to concatenate the values together to make a MASTER KEY value. When doing that I usually add a separator that never appears in any of the values. In your case it could be a space character. I have used dash (-), comma(-), etc. By using a unique separator, I can extract all the values from the key by using the Split() function provided by Excel.

For example (tested and working):

Please Login or Register  to view this content.

Lewis