+ Reply to Thread
Results 1 to 3 of 3

selecting options on drop down list on web form

  1. #1
    Registered User
    Join Date
    09-16-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Smile selecting options on drop down list on web form

    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" />&nbsp;
    <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
    Attached Files Attached Files
    Last edited by Shane of the Newbs; 11-30-2011 at 11:26 AM. Reason: Solved

  2. #2
    Forum Contributor
    Join Date
    05-09-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    315

    Re: selecting options on drop down list on web form

    Try something like this. Obviously you'll need to change www.websiteurl.com to your actual website.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-16-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: selecting options on drop down list on web form

    Thank you heaps Mojo,

    The code works perfectly, I now have control of the whole web form.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1