title: How to assign excel cell with string to array value in visual basic?
body: <p>I'm pretty new to visual basic, but I'm having trouble assigning cell values to members of an array.  Basically what I am doing is looping through a column and assigning each cell to a new part of the array.  Test code is posted below:</p>
  
  <pre><code>Sub Test()
      Dim List(5) As String
      Dim celltext As String
  
      For i = 1 To 5
          celltxt = ActiveSheet.Range("K" &amp; i).Text
          List(i) = celltext
          MsgBox List(i)
      Next i
  End Sub
  </code></pre>
  
  <p>Each time the message box pops up though, it is blank, meaning that the assignment didn't work.  The cells at those coordinates DO have values.  Any clues?</p>