title: Using an Array as argument in Case Select statement
body: <p>Based on certain information, my excel file is in a certain 'status'. For example we have the process of an service; (1)request, (2)process, (3)payment.
  After checking if all the information is provided a function returns a 1 or a 0. 1 is all the information is present, 0 if it is not.</p>
  
  <pre><code>Dim Status(1 to 3) as Integer
  
  CheckFunction(Request)
  Status(1)= CheckFunction 'Return 1 
  CheckFuntion(Process)
  Status(2)= CheckFunction 'Return 1
  CheckFuntion(Payment)
  Status(3)= CheckFunction 'Return 0
  </code></pre>
  
  <p>Now my array looks like this</p>
  
  <pre><code>Status(1, 1, 0)
  </code></pre>
  
  <p>This file should now be in the 'Process' status.
  I want to use this so determine the current status of the service, like;</p>
  
  <pre><code>Select Case Status()
  
  Case (1, 0, 0)
    'Some code
  Case (1, 1, 0)
    'Some code
  Case (1, 1, 1)
    'Some code
  
  End Select
  </code></pre>
  
  <p>But i cant get this to work properly. Iv got a total of 15 different statuses and this to me seems to most elegant way to do this.</p>
  
  <p>Can someone help me out? </p>