title: How to enter data into IE webpage form from excel cell
body: <p>I did a lot of searching prior to this without success.  Links searched included at least the links at the bottom of this post.  PLEASE HELP.</p>
  
  <p>The website in question is <a href="https://vcheck.ttc.lacounty.gov/proptax.php?page=main" rel="nofollow noreferrer">https://vcheck.ttc.lacounty.gov/proptax.php?page=main</a> and you get to the relevant APN input screen after beating a CAPTCHA and click the "Property Tax Inquiry/One-Time Payment" link.  Then you can enter an APN number.  </p>
  
  <p>I was able to piece all the code to get me to the webpage, but none of my attempts to enter in an APN number from my excel sheet are working.  Code is below.  The 1234567891 is merely an example, I really want it to pull from Sheet 1 and whatever cell I choose.  I found code to do that piece, but the web page never populates :(</p>
  
  <pre><code>Private Sub cmdAPNenter_Click()
  
  Dim ie As SHDocVw.InternetExplorer
  
  Set ie = New SHDocVw.InternetExplorer
  
  ie.Visible = True
  
  ie.Navigate "https://vcheck.ttc.lacounty.gov/proptax.php?page=main" 
  'we are going to los angeles property tax page
  
  Do
  
  DoEvents
  
  Loop Until ie.ReadyState = 4
  
  'ie READYSTATE has 5 different status codes, here we are using status 4:
  
  'Uninitialized = 0
  
  'Loading = 1
  
  'Loaded = 2
  
  'Interactive = 3
  
  'Complete = 4
  
  Call ie.Document.GetElementByID("theform").SetAttribute("value", "1234567891")
  
  
  Do
  
  DoEvents
  
  Loop Until ie.ReadyState = 3
  
  Do
  
  DoEvents
  
  Loop Until ie.ReadyState = 4
  
  End Sub
  </code></pre>
  
  <p><a href="https://stackoverflow.com/questions/17409613/vba-to-enter-data-online-and-submit-form">VBA to Enter Data Online and Submit Form</a>
  <a href="https://stackoverflow.com/questions/18614782/how-to-copy-data-from-a-cell-in-excel-to-a-webpage-text-field">How to copy data from a cell in Excel to a webpage text field?</a>
  <a href="https://stackoverflow.com/questions/20611714/input-text-into-html-input-box-using-vba">Input text into html input box using vba</a></p>