title: How to enter values from inputbox in excel and store them in newline using vbscript every time
body: <p>I am trying to add values from an InputBox to Excel worksheet cells which I have  created using VBScript.</p>
  
  <p>I am able to store values in worksheet cells whenever I am entering the values in InputBox but my issue is that I have hardcoded the cell values and by using that I have assigned values to my InputBox that where to put the InputBox data in worksheet cells so whenever I am running my vbs file it is replacing the old values stored in those particular cells but instead I want to make it like every time I run my VBScript it will store the InputBox data in a new line and will also keep the old entries in worksheet cells saved but I am not sure how to do that.</p>
  
  <p>Below is my code for your reference:</p>
  
  <pre><code>sInput = InputBox("Enter your name")
  
  MsgBox ("You entered:" &amp; sInput)
  
  sInput1 = InputBox("Enter your name")
  
  MsgBox ("You entered:" &amp; sInput)
  
  Set objExcel = CreateObject("Excel.Application")
  Set objWorkbook = objExcel.Workbooks.Open("C:\Users\saurabh.ad.sharma\Desktop\rrr.xlsx")
  
  objExcel.Application.Visible = True
  
    objExcel.Cells(1,1).Value= sInput
    objExcel.Cells(1,2).Value= sInput1
  
  objExcel.ActiveWorkbook.Save 
  objExcel.ActiveWorkbook.Close
  
  objExcel.Application.Quit
  WScript.Echo "Finished."
  WScript.Quit
  </code></pre>