Hi All,
I am using excel vba to fill out a web form which contains a drop down list. I have sorted out how to access all the other fields and buttons, but can not change the selection of the drop down list, and have found nothing useful thorugh web and forum searches.
The problem is this
Picture of the drop down box attached,
source code for drop down list below
How do change the dropdown list selection? I am using excel 2003.
<TD style="HEIGHT: 71px" class="fInput">
<input name="txtA4_QtyToSend" type="text" size="10" id="txtA4_QtyToSend" />
<span id="lblQtyToSendUnit">EA</span></TD>
</TR>
<TR>
<TD style="FONT-SIZE: xx-small" class="fLabel" noWrap><B><B>Reimbursement:</B></B></TD>
<TD class="fInput">
<select name="ddlA4_Reimbursement" id="ddlA4_Reimbursement">
<option selected="selected" value="Replace and Credit upon return">Replace and Credit upon return</option>
<option value="Replace charge">Replace charge</option>
<option value="Replace free">Replace free</option>
<option value="Replace with trade in credit upon return">Replace with trade in credit upon return</option>
<option value="Extended warranty, Replace and Credit upon return">Extended warranty, Replace and Credit upon return</option>
<option value="Credit">Credit</option>
<option value="Credit upon return">Credit upon return</option>
<option value="NA">NA</option>
</select></TD>
</TR>
<TR>
<TD style="FONT-SIZE: xx-small" class="fLabel" noWrap><B><B>Reimbursement Ref:</B></B></TD>
<TD class="fInput">
<P>
Thank You in advance for your help
Shane
Bookmarks