Setting JSP page option list from VBA

Question

I'm trying to use Excel2000 VBA to control a webpage.

I can easily select controls like this:

<select name="List2" >

<option value="1" >Weekly</option>

<option value="2" >Two Weeks</option>

<option value="3" >Three Weeks</option>

<option value="4" selected>Four Weeks</option>

</select>

But the page also includes this control which I cannot manage (Note the absence of "value=" coding):

<select name="List1" >

<option>03/31/01</option>

<option>04/08/01</option>

<option>04/15/01</option>

</select>

Thanks in advance.

Answer 1

In that case, you want to access the Text property of the control.