title: VBA to Enter Data Online and Submit Form
body: <p>I'm trying to use VBA to submit data from Excel to a webform online. The issue happens within the <strong>*</strong> area where I'm trying to select and update the form. I've tried a variety of options (getelement by ID, name, etc.) without any success. I believe the issue has to do with identifying the appropriate element.  I've seen advice about using the Locals feature in VBA, but I'm not sure how to use that for this purpose.  I have a feeling someone with some experience could figure this out very quickly by looking at the source code on the webiste, using Locals in VBA, or some other technique.</p>
  
  <p>The form is set up so all fields are text and I can enter/submit data online with no problem.</p>
  
  <p>Thanks in advance for any help/suggestions.</p>
  
  <pre><code>Dim IE As Object
  
  Sub submitFeedback3()
  Application.ScreenUpdating = False
  
  Set IE = CreateObject("InternetExplorer.Application")
  IE.Visible = True
  IE.Navigate "http://spreadsheetbootcamp.com/excel-efficiency-trainer-feedback/"
  
  Application.StatusBar = "Submitting"
    ' Wait while IE loading...
   While IE.Busy
   DoEvents
   Wend
   **********************************************************************
   IE.Document.getElementById("Form_Attempts-1372643500")(0).Value = "1"
   IE.Document.getElementById("submit-1-1372643500")(0).Click
   **********************************************************************
   Application.StatusBar = "Form Submitted"
   IE.Quit
   Set IE = Nothing
  
  Application.ScreenUpdating = True
  End Sub
  </code></pre>