how to double click html table cells to input values

yvonne_yuan

New Member
Joined
Apr 19, 2016
Messages
9
Hi everyone,

I'm not very familiar with VBA code, I have one issue that not figured out for few days, and very upset now, anyone could help me?
I want to insert values to a HTML table cells, but the cells is read-only for first page load and if user double click the cells then the cells input tag is is display, you can see the difference html code as below.
I have tried .fireevent "ondblclcik" and .fireevent "onmousekeydown", but it does not work. I just found .fireevent "ondblclick" return false

Before double click the html source:
< div class="grid_read_div" style="left: 0px; top: 0px; display: none;" id="gridTablePanel">< /div>

after double click the html source:
< div class="grid_edit_div" style="left: 303px; top: 289px;" id="gridTablePanel">< select id="C2" class="htmlElm" style="width: 53px;" onkeydown="AGILE.grid.HTMLElementMgr.validateEvent(event)">< option value="-1" selected="">< /option>< option value="2658527">Cancel< /option>< option value="2658526">No< /option>< option value="2658525">Yes< /option>< /select>< /div>

full table html source code:
< table style="" class="GMMainTable" id="PSRTABLE_AFFECTEDITEMS" *******="return Grids[0].GridClick(event)" onmousemove="return Grids[0].GridMouseMove(event)" ***********="return Grids[0].GridMouseOver(event)" onmousedown="return Grids[0].GridMouseDown(event)" onmouseup="return Grids[0].GridMouseUp(event)" ondblclick="return Grids[0].GridDblClick(event)" oncontextmenu="return Grids[0].GridRightClick(event)" cellpadding="0" cellspacing="0">
< tbody>
< tr>
< td style="overflow:hidden;">
< div class="GMHeadLeft" style="overflow:hidden;">
< table class="GMSection" cellpadding="0" cellspacing="0">
< tbody>
< tr>
< th style="height:0px;width:17px;">< /th>
< th style="height:0px;width:49px;">< /th>
< th style="height:0px;width:20px;">< /th>
< /tr>
< tr class="GMHeaderRow" style="height: 28px;">
< td class=" GPanelTopHeader GMCellHeaderPanel">
< u class="GMPanelSelectOff GMImage">< /u>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_4870" title="Item Number">Item Number< /span>
< /td>
< /tr>
< /tbody>
< /table>
< /div>
< /td>
< td style="overflow:hidden;">
< div class="GMHeadMid" style="overflow: hidden; width: 1515px;">
< table class="GMSection" cellpadding="0" cellspacing="0">
< tbody>
< tr>
< th style="height:0px;width:194px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:36px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:73px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:95px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:181px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:86px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:79px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:55px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:55px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:280px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:280px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:280px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:5px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:280px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:1px;">< /th>
< th style="height:0px;width:14px;">< /th>
< th style="height:0px;width:1px;">< /th>
< th style="height:0px;width:14px;">< /th>
< th style="height:0px;width:55px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height: 0px; width: 1px;">< /th>
< th style="height: 0px; width: 0px;">< /th>
< /tr>
< tr class="GMHeaderRow" style="height: 28px;">
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6638" title="Item Description">Item Description< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7568" title="FA Flag">FA Flag< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6635" title="Service Order Number-Line Number">Service Order Number-Line Number< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7558" title="Return Reason Code">Return Reason Code< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7553" title="Customer Reported Serial Number">Customer Reported Serial Number< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7556" title="H/W Revision">H/W Revision< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7557" title="S/W Revision">S/W Revision< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6666" title="CFA Eligible">CFA Eligible< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6667" title="BU FA Eligible">BU FA Eligible< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6668" title="End of FA">End of FA< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6636" title="Cisco Received Date">Cisco Received Date< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_2000007979" title="Unit Manufacturing Date Code">Unit Manufacturing Date Code< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7554" title="Cisco Received Serial Number">Cisco Received Serial Number< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6633" title="Site Received Serial Number">Site Received Serial Number< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_2000009197" title="Site Received S/W Revision">Site Received S/W Revision< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_2000009198" title="CDETS#">CDETS#< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7569" title="Part Received">Part Received< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6630" title="Physical Inventory Location">Physical Inventory Location< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6642" title="Part Receiving Notes">Part Receiving Notes< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7567" title="Rev Found">Rev Found< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6686" title="Latest Rev">Latest Rev< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_4873" title="FA Failure Mode">FA Failure Mode< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7573" title="FA Failure Code">FA Failure Code< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7563" title="Parent Serial Number">Parent Serial Number< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_2000008005" title="Parent Part Number">Parent Part Number< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7571" title="Manufacturer">Manufacturer< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7572" title="Manufacturer Part Number">Manufacturer Part Number< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7559" title="Component Serial Number">Component Serial Number< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7560" title="Component Date Code">Component Date Code< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7561" title="Component Lot Code">Component Lot Code< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7564" title="RefDes Location">RefDes Location< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7565" title="RMA Originating Theater">RMA Originating Theater< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6634" title="Advanced Shipment Notice">Advanced Shipment Notice< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6641" title="Item Type">Item Type< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6508" title="Authorized Qty">Authorized Qty< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7548" title="Received Qty">Received Qty< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7549" title="Cancelled Qty Prior to Case Submit">Cancelled Qty Prior to Case Submit< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6787" title="Rev Found - Make Not Visible">Rev Found - Make Not Visible< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_4872" title="Rev Fixed">Rev Fixed< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6671" title="Product Family">Product Family< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6674" title="Critical/Non Critical">Critical/Non Critical< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_6673" title="FCS Status">FCS Status< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_2000007999" title="Reasons for Initiating RC">Reasons for Initiating RC< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_2000008000" title="Reasons for not initiating RC">Reasons for not initiating RC< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_2000008001" title="RC Path">RC Path< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_2000008006" title="Create OEM / Root Cause Case">Create OEM / Root Cause Case< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_2000008002" title="RC Priority">RC Priority< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_2000008003" title="QIT  Disposition PID/Comp">QIT Disposition PID/Comp< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_2000008004" title="OEM / ODM Type">OEM / ODM Type< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_2000008007" title="SW- RC Path Name">SW- RC Path Name< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_2000008008" title="SW Received Resolution Status">SW Received Resolution Status< /span>
< /td>
< td style="background-color:rgb(239,239,239)" class=" GMRow GMHeaderText GMCellHeader" colspan="2">
< span id="i_7555" title="Ship To Country">Ship To Country< /span>
< /td>
< td class=" GMRow GMHeaderText GMCellHeaderEmpty" colspan="2">< /td>
< /tr>
< /tbody>
< /table>
< /div>
< /td>
< td rowspan="3" valign="top">
< div class="GMVScroll" style="width: 17px; display: none;">
< div style="width:17px;overflow:auto;" onscroll="Grids[0].Scrolled();" onmousemove="Grids[0].ARow=null;Grids[0].ASec=-1;">
< div style="width:1px;overflow:hidden;"> < /div>
< /div>
< /div>
< /td>
< td rowspan="5" style="display:none;" valign="top">
< div class="GMPagerMain" style="width:100px;height:20px;overflow:hidden;white-space:nowrap;" onmousemove="Grids[0].ARow=null;Grids[0].ASec=-6;">
< div class="GMPagerHeader">
< div class="GMPagerCaption">Pager< /div>
< /div>
< div class="GMPagerBody" style="overflow:auto;">
< div>
< div>< /div>
< div class="GMPagerCursor" style="height:20px;overflow:hidden;"> < /div>
< /div>
< /div>
< /div>
< /td>
< /tr>
< tr>
< td style="overflow:hidden;">
< div class="GMBodyLeft" style="overflow: hidden; height: 21px;">
< div class="GMPageOne">
< table class="GMSection" cellpadding="0" cellspacing="0">
< tbody>
< tr>
< th style="height:0px;width:17px;">< /th>
< th style="height:0px;width:49px;">< /th>
< th style="height:0px;width:20px;">< /th>
< /tr>
< tr class="GMDataRow" style="height:21px;">
< td style="background-color: rgb(159, 159, 159);" class=" GMPx1xx GMCellPanel GMEmpty selected_row"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">
< a tabindex="-1" href="javascript:noaction();" ***********="showQuickViewLink(event, this)" **********="cancelQuickViewTimer(this);" *******="javascript:displayItem('ItemHandler', '10000', '44972144', '0', 'RightPane', '0', '', '0', '0', '0');" class="image_link" infourl="showObjectInfo('10000', '44972144', '201363007', '4870', 'R0', 'true', 'PSRTABLE_AFFECTEDITEMS');">CP-3905=< /a> 
< /td>
< /tr>
< /tbody>
< /table>
< /div>
< div style="height:0px;overflow:hidden;">< /div>
< /div>
< /td>
< td style="overflow:hidden;">
< div class="GMBodyMid" style="overflow: hidden; width: 1515px; height: 21px;">
< div class="GMPageOne">
< table class="GMSection" cellpadding="0" cellspacing="0">
< tbody>
< tr>
< th style="height:0px;width:194px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:36px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:73px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:95px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:181px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:86px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:79px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:55px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:55px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:280px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:280px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:280px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:5px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:280px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:1px;">< /th>
< th style="height:0px;width:14px;">< /th>
< th style="height:0px;width:1px;">< /th>
< th style="height:0px;width:14px;">< /th>
< th style="height:0px;width:55px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height: 0px; width: 1px;">< /th>
< th style="height: 0px; width: 0px;">< /th>
< /tr>
< tr class="GMDataRow" style="height: 21px;">
< td style="background-color: rgb(255, 255, 255);" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">Cisco Unified SIP Phone 3905, Charcoal, Standard Handset  < /td>
< td style="background-color: rgb(201, 221, 255);" class=" GMColorReadOnly GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color: rgb(255, 255, 255);" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">900046014-2  < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">DOA- DEAD ON ARRIVAL  < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorReadOnly GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorReadOnly GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorReadOnly GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">Y< /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">Y< /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">
< img class="gridIconSize" src="/Agile/static/7edfadf3763ac1170dfb6eb026ed98d0/images/ico_status_no_read_priv.png" title="No Privilege"> 
< /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">No< /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorReadOnly GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">-E0  < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">JPN  < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">PID< /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">1< /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">0< /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">0< /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">Introductory< /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">
< a tabindex="-1" href="javascript:noaction();" ***********="showQuickViewLink(event, this)" **********="cancelQuickViewTimer(this);" *******="javascript:displayObject('PartFamilyHandler', '2000004409', '6023882', '0');" class="image_link" infourl="showObjectInfo('2000004409', '6023882', '0' , '6671', 'R0', 'false', 'PSRTABLE_AFFECTEDITEMS');">PHONE< /a> 
< /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">
< img class="gridIconSize" src="/Agile/static/7edfadf3763ac1170dfb6eb026ed98d0/images/ico_status_no_read_priv.png" title="No Privilege"> 
< /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">
< img class="gridIconSize" src="/Agile/static/7edfadf3763ac1170dfb6eb026ed98d0/images/ico_status_no_read_priv.png" title="No Privilege"> 
< /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorReadOnly GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorReadOnly GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorReadOnly GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorReadOnly GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorReadOnly GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorReadOnly GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorReadOnly GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell GMEmpty" colspan="2"> < /td>
< td style="background-color:rgb(255,255,255)" class=" GMColorNoFocus GMRow GMText GMCell" colspan="2">
< img class="gridIconSize" src="/Agile/static/7edfadf3763ac1170dfb6eb026ed98d0/images/ico_status_no_read_priv.png" title="No Privilege"> 
< /td>
< td class=" GMRow GMHtml GMCellEmpty GMEmpty" colspan="2"> < /td>
< /tr>
< /tbody>
< /table>
< /div>
< div style="height:0px;overflow:hidden;">< /div>
< /div>
< /td>
< /tr>
< tr>
< td colspan="2">
< div style="width: 1601px; overflow: hidden; height: 20px;" class="GMSpaceRow">
< table cellpadding="0" cellspacing="0">
< tbody>
< tr style="height:21px;">
< td>< /td>
< /tr>
< /tbody>
< /table>
< /div>
< /td>
< /tr>
< tr style="display:none;">
< td style="overflow:hidden;">
< div class="GMFootLeft GMNone" style="overflow:hidden;">
< table class="GMSection" cellpadding="0" cellspacing="0">
< tbody>
< tr>
< th style="height:0px;width:17px;">< /th>
< th style="height:0px;width:49px;">< /th>
< th style="height:0px;width:20px;">< /th>
< /tr>
< /tbody>
< /table>
< /div>
< /td>
< td style="overflow:hidden;">
< div class="GMFootMid GMNone" style="overflow: hidden; width: 1515px;">
< table class="GMSection" cellpadding="0" cellspacing="0">
< tbody>
< tr>
< th style="height:0px;width:194px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:36px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:73px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:95px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:181px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:86px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:79px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:55px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:55px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:280px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:280px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:280px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:5px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:30px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:280px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:1px;">< /th>
< th style="height:0px;width:14px;">< /th>
< th style="height:0px;width:1px;">< /th>
< th style="height:0px;width:14px;">< /th>
< th style="height:0px;width:55px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height:0px;width:80px;">< /th>
< th style="height:0px;width:20px;">< /th>
< th style="height: 0px; width: 1px;">< /th>
< th style="height: 0px; width: 0px;">< /th>
< /tr>
< /tbody>
< /table>
< /div>
< /td>
< /tr>
< tr>
< td colspan="2">
< div class="GMHScroll" style="height: 17px; overflow: hidden; width: 1603px;">
< div style="height: 17px; overflow: auto; width: 1603px;" onscroll="Grids[0].Scrolled();" onmousemove="Grids[0].ARow=null;Grids[0].ASec=-3;">
< div style="height: 1px; overflow: hidden; width: 5782px;"> < /div>
< /div>
< /div>
< /td>
< td style="display: none;" onmousemove="Grids[0].ARow=null;Grids[0].ASec=-5;">
< div class="GMXScroll" style="height:17px;width:17px;overflow:hidden;"> < /div>
< /td>
< /tr>
< tr style="display:none;">
< td colspan="3">
< div style="width: 1600px;" class="GMToolbarRow">
< table cellpadding="0" cellspacing="0">
< tbody>
< tr style="height:21px;">
< td onmousemove="Grids[0].TmpSpaceCol="Save";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMHidden">< /td>
< td onmousemove="Grids[0].TmpSpaceCol="Reload";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolReload GMEmpty"> < /td>
< td onmousemove="Grids[0].TmpSpaceCol="Repaint";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolRepaint GMEmpty"> < /td>
< td onmousemove="Grids[0].TmpSpaceCol="Print";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolPrint GMEmpty"> < /td>
< td onmousemove="Grids[0].TmpSpaceCol="Export";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMHidden">< /td>
< td onmousemove="Grids[0].TmpSpaceCol="Add";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolAdd GMEmpty"> < /td>
< td onmousemove="Grids[0].TmpSpaceCol="AddChild";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMHidden">< /td>
< td onmousemove="Grids[0].TmpSpaceCol="Sort";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolSort1 GMEmpty"> < /td>
< td onmousemove="Grids[0].TmpSpaceCol="Calc";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolCalc GMEmpty"> < /td>
< td onmousemove="Grids[0].TmpSpaceCol="ExpandAll";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMHidden">< /td>
< td onmousemove="Grids[0].TmpSpaceCol="CollapseAll";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMHidden">< /td>
< td onmousemove="Grids[0].TmpSpaceCol="Columns";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolColumns GMEmpty"> < /td>
< td onmousemove="Grids[0].TmpSpaceCol="Cfg";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolCfg GMEmpty"> < /td>
< td onmousemove="Grids[0].TmpSpaceCol="Help";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolHelp GMEmpty"> < /td>
< td onmousemove="Grids[0].TmpSpaceCol="Debug";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMHidden">< /td>
< td onmousemove="Grids[0].TmpSpaceCol="StyleTitle";" class=" GMRow GMCellSpace GMHtml">
< span style="color:#999;">Style:< /span>
< /td>
< td onmousemove="Grids[0].TmpSpaceCol="StyleStandard";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolIcon">Standard< /td>
< td onmousemove="Grids[0].TmpSpaceCol="StyleLight";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolIcon">Light< /td>
< td onmousemove="Grids[0].TmpSpaceCol="StyleOffice";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolIcon">Office< /td>
< td onmousemove="Grids[0].TmpSpaceCol="StyleModern";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolIcon1">Modern< /td>
< td onmousemove="Grids[0].TmpSpaceCol="StyleBorders";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolIcon">Borders< /td>
< td onmousemove="Grids[0].TmpSpaceCol="StyleRobust";" style="background-color:rgb(255,255,255)" class=" GMRow GMCellSpace GMToolIcon">Robust< /td>
< td onmousemove="Grids[0].TmpSpaceCol="Empty";" class=" GMRow GMCellSpace GMHtml">
< div style="cursor: default; padding-top: 2px; padding-left: 3px; padding-right: 3px; white-space: nowrap; font: 9px arial; color: rgb(119, 119, 119); width: 3200px; overflow: hidden;">
< span style="cursor:pointer;" title="http://www.treegrid.com/" *******="************("http://www.treegrid.com/");">EJS TreeGrid v6.0< /span>
< /div>
< /td>
< td onmousemove="Grids[0].TmpSpaceCol="Formula";" class=" GMRow GMCellSpace GMText"> < /td>
< td onmousemove="Grids[0].TmpSpaceCol="Resize";" class=" GMRow GMCellSpace GMHidden">< /td>
< /tr>
< /tbody>
< /table>
< /div>
< /td>
< /tr>
< /tbody>
< /table>
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,215,678
Messages
6,126,176
Members
449,296
Latest member
tinneytwin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top