Creating an Array with Names instead of Index Numbers

[redbrad0]

In c# .net I can create and array with using the name like arrayNames("John") = "john@me.com" but in excel VBA I cant find any documents that say this is possible as everything seems to reference the index number of the array. Basically what I am trying to do is read in settings for the excel file from the settings Worksheet I created so we a new column is added, the setting is automatically read into the application with the name of it. So then when I want to know the value of setting ABC I can just call arrayNames("John"). Is this possible?

Example:

arraySettings("AddRanking") = "Yes"
arraySettings("HighlightOverages") = "No"

if arraySettings("AddRanking") = "Yes" then
     ' # They want to add the ranking of the user so process that code
     if arraySettings("HighlightOverages") = "Yes"
          ' # They want highlight any overages so lets start to highlight
     end if
end if

[Bob Phillips]

Try using a collection instead.