Demo how to automatically populate a web form with VBA.

VBA

VBA code which opens the form in the web browser.  Then finds the input boxes by their name and inputs the values into the fields.

https://www.vba-market.com/AutoPopulateForm.xlsm

Option Explicit
Sub PopulateForm()
Dim doc, hcol, text As Variant
Dim ie As SHDocVw.InternetExplorer
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.Navigate ("https://www.vba-market.com/project-form/")
Do While ie.ReadyState <> READYSTATE_COMPLETE
    DoEvents
    Loop
    While ie.Busy
    DoEvents
    Wend

    Set doc = ie.Document
    Set hcol = doc.getElementsByTagName("input")
        For Each text In hcol
            If text.Name = "your-name" Then
                text.Value = "Dylan Gregory"
            End If
        Next
    Set doc = ie.Document
    Set hcol = doc.getElementsByTagName("input")
        For Each text In hcol
            If text.Name = "your-email" Then
                text.Value = "helpdesk@vba-market.com"
            End If
        Next
    Set doc = ie.Document
    Set hcol = doc.getElementsByTagName("input")
        For Each text In hcol
            If text.Name = "project-summary" Then
                text.Value = "Auto Populate Form with VBA"
            End If
        Next
        Set doc = ie.Document
    Set hcol = doc.getElementsByTagName("textarea")
        For Each text In hcol
            If text.Name = "project-detail" Then
                text.Value = "Demo of how to Auto Populate an HTML Form with VBA. "
            End If
        Next
    Set doc = ie.Document
    Set hcol = doc.getElementsByTagName("input")
        For Each text In hcol
            If text.Name = "project-budget" Then
                text.Value = "$200.00 "
            End If
        Next
            Set doc = ie.Document
    Set hcol = doc.getElementsByTagName("input")
        For Each text In hcol
            If text.Name = "date-496" Then
                text.Value = Now
            End If
        Next

End Sub

HTML

Simplified version of the HTML code for the web form.  Key value to look for is either the name of the field or the ID.

 

<html>
<body>
  <form>
    <input name= your-name" value="" />
    <input name="your-email" value="" />
    <input name="project-summary" value="" />
    <textarea name="project-detail" value=""> </textarea>
    <input name="project-budget" value="" />
    <input name="date-496" value="" />
  </form>
</body>
</html>