JiggyPiggy
Programmer
I have been able to complete webforms through VBA and Excel data using something like...
Dim HTMLBoxDoc as HTMLDocument
HTMLBoxDoc.forms("form1").Item(itemname in site code).value = whatever i want it to be
'Submit the page
HTMLBoxDoc.forms("form1").Submit
The issue I am having is when the site contains a listbox. I can select one item from the list box (using the value code from the source instead of the displayed value) but I cannot figure out how to select multiple items from the list box (it is a multi listbox) through code. I would really prefer not to have to use SendKeys.
Dim HTMLBoxDoc as HTMLDocument
HTMLBoxDoc.forms("form1").Item(itemname in site code).value = whatever i want it to be
'Submit the page
HTMLBoxDoc.forms("form1").Submit
The issue I am having is when the site contains a listbox. I can select one item from the list box (using the value code from the source instead of the displayed value) but I cannot figure out how to select multiple items from the list box (it is a multi listbox) through code. I would really prefer not to have to use SendKeys.