title: Input textbox value is empty when submiting a web form in vba
body: <p>I am trying to submit a webform by giving all the values in form input text boxes but when i call the submit button click from excel vba, one of the text boxes is becoming empty and throwing a validation error.</p>
  
  <pre><code>Sub Click_Btn()    
    Dim objForms As Object
    Dim vTxtInput As Variant
    'Set objIE = GetIEApp
    Set objIE = New InternetExplorer
  
    'Make sure an IE object was hooked
    If TypeName(objIE) = "Nothing" Then
      MsgBox "Could not hook Internet Explorer object", _
        vbCritical, "GetFields() Error"
      'GoTo Clean_Up
    End If
    objIE.Navigate "http://fly3.emirates.com/CAB/IBE/SearchAvailability.aspx"
    objIE.Visible = True
  
    Sleep 5000
  
    Set objForms = objIE.document.all
  
    'Choose one way Flights
    objIE.document.getElementById("ctl00_c_CtWNW_onewaySearch").Click
    Sleep 1000
  
    objIE.document.getElementById("ctl00_c_CtWNW_ddlTo-suggest").Value = "Sydney (SYD)"
  
    ' Departure
    objIE.document.getElementById("ctl00_c_CtWNW_ddlFrom-suggest").Value = "Mumbai (BOM)"
  
    ' Departure Date
    objIE.document.getElementById("ctl00_c_CtWNW_txtDepartDate").Value = "28 Sep 12"
    Sleep 1000
  
    objIE.document.getElementById("ctl00_c_FS_FF").Click
  End Sub
  </code></pre>
  
  <p>When i click the submit button for the form the <code>ctl00_c_CtWNW_ddlTo-suggest</code> text box is becoming empty and getting an error.</p>