Hello, I am trying to build an VBA interface through excel where the filled in answers are also being processed in the google form (so basically the questions or the fields online are on the vba interface). I have managed to send the text box answers to the google docs file but I am struggling with the checkboxes that I have. Is there anyone with experience on vba check boxes and google forms checkboxes? The code below is without the check boxes.
VBA Code:
Dim SendLink As String, StartLink As String, EndLink As String, HeaderName As String, SendID As String
Dim ReportedBy As String, Desk As String, License As String, Material As String, TroubleSolving As String
Dim TicketInfo As MSXML2.ServerXMLHTTP60
HeaderName = "Content-Type"
SendID = "application/x-www-form-urlencoded; charset=utf-8"
'Get Form Details
ReportedBy = SubmitTicketForm.SenderName.Value 'Reported By Name
Desk = SubmitTicketForm.Desk.Value 'Desk
License = SubmitTicketForm.License.Value 'Reported License
Material = SubmitTicketForm.Material.Value 'SKU
StartLink = "https://docs.google.com/forms/d/e/ -Remaining part of the Link"
EndLink = "&entry.341133=" & ReportedBy & "&entry.1033118495=" & Desk & "&entry.1456399398=" & License & "&entry.2071487927=" & Material & "&entry.422813657=" & TroubleSolving & "&submit=Submit"