Hi,

I'm trying to write a module that has Select/Case statements in which the arguments are based on a text file (I am doing this b/c I want the conditions/arguments in the select/case statement to be able to be changed by someone who does not know VB).

For example, the text file may look something like:

Note: I inserted the periods between the table entries/headings so that I could get the correct spacing for this post, they wouldn't be included int he actual text file

Case..........Argument.........Return Value
----------------------------------------
1...............NYC...............East Coast
2...............LA.................West Coast
3...............ATL...................South

Using this text file, I'd like to be able to write something along the following lines:

dim location As String

Select Case location
Case location = 1 'this would be based on the cases listed in the text file(e.g. in this case 1 corresponds to NYC)
MsgBox [Return Value 1] 'this is also based on the text file (e.g. above)
Case location = 2
MsgBox [Return Value 2]
Case location = 3
MsgBox [Return Value 3]
End Select

Essentially, the text file would consist of a limited number of cases which a user could adjust. If these cases were changed, the select/case statement, being linked to the contents of the file, would change accordingly.

Thanks for your help.