Select Radio Buttons in IE

[OHtoMSP]

I'm attempting to use VBA from excel to select one of two radio buttons in internet explorer. I can get the webpage to open, but cannot get the radio buttons selected.

Below is the code of the webpage. I want it to select the Cartons radio button.

<TABLE width="100%" border="0">
<TR>
<TD width="30%"><!--<input type="radio" name="UNIT_EACHES" value="" ******* = "javascript:eachesRadioClick();"/>EACHES-->
<input type="radio" tabindex="10" style="color: #FF0000"
                   name="UNIT_MEASURE"
                   value="Units"
                   >  Units</TD>
                                                      </TR>
                                                      <TR>
<TD width="30%"><!--  <input type="radio" name="UNIT_CASES" value="" ******* = "javascript:casesRadioClick();"  />CASES  -->
<input type="radio" style="color: #FF0000" name="UNIT_MEASURE"
                  value="Cartons"
                                              >  Cartons</TD>
                                                      </TR>
                                               </TABLE>

 

[Norie]

What code do you have so far?

 

[AlphaFrog]

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> Select_Cartons()<br><br>    <SPAN style="color:#007F00">' Set a reference to 'Microsoft Internet Controls' under the VBA Tools\References menu</SPAN><br>    <SPAN style="color:#00007F">Dim</SPAN> IE <SPAN style="color:#00007F">As</SPAN> InternetExplorer<br>    <br>    <SPAN style="color:#00007F">Set</SPAN> IE = <SPAN style="color:#00007F">New</SPAN> InternetExplorer<br>    <br>    IE.Navigate "http://www.mrexcel.com/forum/showthread.php?t=574836"<br>    IE.Visible = <SPAN style="color:#00007F">True</SPAN><br>    <SPAN style="color:#00007F">Do</SPAN><br>        DoEvents<br>    <SPAN style="color:#00007F">Loop</SPAN> <SPAN style="color:#00007F">Until</SPAN> IE.ReadyState = READYSTATE_COMPLETE<br>    <br>    IE.Document.All("UNIT_MEASURE").Item(1).Checked = <SPAN style="color:#00007F">True</SPAN><br>    <br>    <SPAN style="color:#007F00">'Select Units</SPAN><br>    <SPAN style="color:#007F00">'IE.Document.All("UNIT_MEASURE").Item(0).Checked = True</SPAN><br>    <br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[OHtoMSP]

Worked perfectly. Thanks!