title: Get User Input and Add it to last index of Array VBA
body: <p>I need to know how can I add an item to an existing array using a user input.</p>
  
  <p>I tried something like this:</p>
  
  <pre><code>Dim MyArray(100) as String
  
  UBound(MyArray) = Inputbox("What's the name of your new array item?")
  </code></pre>