I've peeled over numerous volumes, both online and off, attempting to figure out how to use Excel VBA to complete an HTML form in order to search for entries in a database that I do not have direct access to but for the HTML form. It contains numerous checkboxes, a text input, and a submit button. I cannot for the life of me figure out how to get the VBA to detect the checkboxes and set them to checked or unchecked. I tried the createobject technique to take control of the Internet Explorer Document Object Model to do it, but I've been confounded by the syntax, meeting with various debugging errors like the object not supported when I use set objCheckbox1 = document.forms.checkbox("C1") code so I can try to use the objCheckbox1.Click() method, among others.

Can somebody please lead me in the right direction so I can code the VBA to control the Internet Explorer Object model? W3C seemed promising, but did not provide the needed example to allow me to figure this out. Even lacking an example, even a book that would allow me to quickly learn this code would be fine.

Thank you in advance.

Thank you.