title: How can i select all ranges in A1 instead of typing each cell reference and link it with input box
body: <blockquote>
  <p>I want Input box to loop through each cell in range A1 and display its value until becomes blank
  How can I write one line code instead of referring each cell</p>
  </blockquote>
  <pre><code>Dim i As Integer
  
  
  For i = 1 To 5
  
  
  
  InputBox (Range(&quot;A1&quot;))
  InputBox (Range(&quot;A2&quot;))
  InputBox (Range(&quot;A3&quot;))
  InputBox (Range(&quot;A4&quot;))
  InputBox (Range(&quot;A5&quot;))
  
  
  Next i '''
  end sub
  </code></pre>