Select dropdown value in a field on Webpage using Excel VBA

G

Gaurish89

New Member
Joined
Apr 27, 2016
Messages
5
I am running out of options, I am trying to select the issue type while creating a defect in JIRA using VBA.
I am taking the login details from the Form.
The field issue type is a dropdown and its not a simple html dropdown, I suspect it is using some Java Code.
Code:
Code: 
******** type="application/json" id="issuetype-defaults">{"11200":"6","10304":"6","10401":"","10402":"","11300":"1","10308":"","10310":"","10918":"6","10919":"","10920":"6","10921":"6","10922":"","10923":"","10000":"","10900":"3","10516":"","10901":"","10522":"","10301":"5"}*********>
 <div class="aui-ss issuetype-ss aui-ss-has-entity-icon" id="issuetype-single-select"><input autocomplete="off" role="combobox" aria-autocomplete="list" aria-haspopup="true" aria-expanded="false" class="text aui-ss-field ajs-dirty-warning-exempt" id="issuetype-field" type="text" aria-controls="issuetype-suggestions"><div class="aui-list" id="issuetype-suggestions" tabindex="-1" role="listbox"></div><span class="icon aui-ss-icon noloading drop-menu"><span>More</span></span><img class="aui-ss-entity-icon" alt="" src="http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11110&avatarType=issuetype"></div>
  <input autocomplete="off" role="combobox" aria-autocomplete="list" aria-haspopup="true" aria-expanded="false" class="text aui-ss-field ajs-dirty-warning- exempt" id="issuetype-field" type="text" aria-controls="issuetype-suggestions">
<span class="icon aui-ss-icon noloading drop-menu"><span>More</span></span>


The current script:
Code: 
Sub StartJira_Click()
    
 'Open IE and hit JIRA Pearson Url
 Set IE = CreateObject("InternetExplorer.Application")
 IE.Silent = True
 IE.Visible = True
 IE.navigate UrlSelect.Value
  
 'Hide VBA form
 JIRAUpdate.Hide
  
 'This code will keep the IE instance active
 Dim sh
 Dim eachIE As Object
 
Do
  Set sh = New Shell32.Shell
  For Each eachIE In sh.Windows
    If InStr(1, eachIE.LocationURL, UrlSelect.Value) Then
      Set IE = eachIE
       Exit Do
      End If
    Next eachIE
  Loop
Set eachIE = Nothing
Set sh = Nothing


 'The new process may still be busy even after you find it
  While IE.Busy
   DoEvents
  Wend


 IE.Document.getElementByID("login-form-username").Value = EditUN.Text 'Enter your username here
 IE.Document.getElementByID("login-form-password").Value = EditPW.Text 'Enter your password here
 IE.Document.getElementByID("login").Click 'Hit login button
 
 Do Until IE.readyState = READYSTATE_COMPLETE
 Loop
 Application.Wait (Now + TimeValue("0:00:10")) 'Wait


 IE.Document.getElementByID("create_link").Click 'Hit Create Issue Button
 Application.Wait (Now + TimeValue("0:00:05")) 'Wait
 IE.Document.getElementByID("qf-create-another").Click 'Selected Create Another Checkbox
 
 Dim X As Integer, Y As Integer, Z As Variant, W As Variant, txt As String, V As Integer
   
      'Set numrows = number of rows of data.
      NumRows = Range("A2", Range("A2").End(xlDown)).Rows.Count
      Y = NumRows + 1
      'Select cell A2, *first line of data*.
      Range("A2").Select
      'Establish "For" loop to loop "numrows" number of times.
      
      For X = 2 To Y
       IE.Document.getElementByID("project-field").Value = Cells(X, 1).Value
       IE.Document.getElementByID("issuetype-field").Click
       Application.Wait (Now + TimeValue("0:00:05")) 'Wait
       IE.Document.getElementByID("issuetype-field").Value = Cells(X, 2).Value
       Application.Wait (Now + TimeValue("0:00:05")) 'Wait
       IE.Document.getElementByID("issuetype-field").Focus
       IE.Document.getElementByID("issuetype-field").Selected = True
       Application.Wait (Now + TimeValue("0:00:05")) 'Wait
       IE.Document.getElementByID("summary").Value = Cells(X, 3).Value
       IE.Document.getElementByID("create-issue-submit").Click
       
      Application.Wait (Now + TimeValue("0:00:05")) 'Wait for 15 second
      
      Z = IE.Document.getElementByID("create-issue-dialog").getElementsByTagName("a")(0).innerText
      Cells(X, 4).Value = Z 'Getting Defect ID in Excel
      
      txt = Cells(X, 4).Value
      W = Split(txt, " ")
      For V = 3 To UBound(W)
        Cells(X, V + 1).Value = W(V - 1)
      Next V
      Columns("F:BB").Delete
      
       ActiveCell.Offset(1, 0).Select
       Application.Wait (Now + TimeValue("0:00:05")) 'Wait for 15 seconds
      Next
    
End Sub


Issue is related to following piece of code:
Code: 
  IE.Document.getElementByID("issuetype-field").Click
       Application.Wait (Now + TimeValue("0:00:05")) 'Wait
       IE.Document.getElementByID("issuetype-field").Value = Cells(X, 2).Value
       Application.Wait (Now + TimeValue("0:00:05")) 'Wait
       IE.Document.getElementByID("issuetype-field").Focus
       IE.Document.getElementByID("issuetype-field").Selected = True


Please help e and let me know if more information is required:)
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Sort by date Sort by votes
The HTML page code
Code: 
<div id="issuetype-options" data-suggestions="[{"label":"10308","items":[{"label":"Please select...","value":"","icon":null,"selected":false},{"label":"Story","value":"6","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Methods And Tools","value":"10103","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11114&avatarType=issuetype","selected":false}]},{"label":"10516","items":[{"label":"Please select...","value":"","icon":null,"selected":false},{"label":"New Feature","value":"2","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11111&avatarType=issuetype","selected":false},{"label":"Task","value":"3","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11118&avatarType=issuetype","selected":false}]},{"label":"10401","items":[{"label":"Please select...","value":"","icon":null,"selected":false},{"label":"Bug","value":"1","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11103&avatarType=issuetype","selected":false}]},{"label":"10301","items":[{"label":"Task","value":"3","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11118&avatarType=issuetype","selected":false},{"label":"Tech Support","value":"10301","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11115&avatarType=issuetype","selected":false},{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false},{"label":"Operation","value":"10300","icon":"http://ybsxw296:8080/images/icons/issuetypes/task_agile.png","selected":false}]},{"label":"10304","items":[{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false},{"label":"Story","value":"6","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false}]},{"label":"10901","items":[{"label":"Please select...","value":"","icon":null,"selected":false},{"label":"Initiative","value":"10502","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11115&avatarType=issuetype","selected":false}]},{"label":"10918","items":[{"label":"Task","value":"3","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11118&avatarType=issuetype","selected":false},{"label":"Story","value":"6","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Bug","value":"1","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11103&avatarType=issuetype","selected":false},{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false}]},{"label":"11200","items":[{"label":"Task","value":"3","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11118&avatarType=issuetype","selected":false},{"label":"Story","value":"6","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Bug","value":"1","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11103&avatarType=issuetype","selected":false},{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false}]},{"label":"10919","items":[{"label":"Please select...","value":"","icon":null,"selected":false},{"label":"Story","value":"6","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false},{"label":"Initiative","value":"10502","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11115&avatarType=issuetype","selected":false}]},{"label":"10921","items":[{"label":"Task","value":"3","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11118&avatarType=issuetype","selected":false},{"label":"Story","value":"6","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Bug","value":"1","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11103&avatarType=issuetype","selected":false},{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false}]},{"label":"10900","items":[{"label":"Task","value":"3","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11118&avatarType=issuetype","selected":false},{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false}]},{"label":"11300","items":[{"label":"Improvement","value":"4","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11110&avatarType=issuetype","selected":true},{"label":"Task","value":"3","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11118&avatarType=issuetype","selected":false},{"label":"New Feature","value":"2","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11111&avatarType=issuetype","selected":false},{"label":"Bug","value":"1","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11103&avatarType=issuetype","selected":false},{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false}]},{"label":"10522","items":[{"label":"Please select...","value":"","icon":null,"selected":false},{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false},{"label":"Task","value":"3","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11118&avatarType=issuetype","selected":false}]},{"label":"10922","items":[{"label":"Please select...","value":"","icon":null,"selected":false},{"label":"Bug","value":"1","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11103&avatarType=issuetype","selected":false},{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false},{"label":"Improvement","value":"4","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11110&avatarType=issuetype","selected":true},{"label":"New Feature","value":"2","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11111&avatarType=issuetype","selected":false},{"label":"Query","value":"10706","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11120&avatarType=issuetype","selected":false},{"label":"Sprint Defect","value":"10708","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11108&avatarType=issuetype","selected":false},{"label":"Requirement","value":"10707","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11115&avatarType=issuetype","selected":false},{"label":"Story","value":"6","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Support","value":"10709","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11109&avatarType=issuetype","selected":false},{"label":"Task","value":"3","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11118&avatarType=issuetype","selected":false},{"label":"Test case","value":"10710","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11106&avatarType=issuetype","selected":false},{"label":"UAT Defect","value":"10711","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11103&avatarType=issuetype","selected":false}]},{"label":"10000","items":[{"label":"Please select...","value":"","icon":null,"selected":false},{"label":"Bug","value":"1","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11103&avatarType=issuetype","selected":false},{"label":"New Feature","value":"2","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11111&avatarType=issuetype","selected":false},{"label":"Task","value":"3","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11118&avatarType=issuetype","selected":false},{"label":"Improvement","value":"4","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11110&avatarType=issuetype","selected":true},{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false},{"label":"Methods And Tools","value":"10103","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11114&avatarType=issuetype","selected":false},{"label":"UX Task","value":"10104","icon":"http://ybsxw296:8080/images/icons/issuetypes/requirement.png","selected":false},{"label":"Tech Task","value":"10105","icon":"http://ybsxw296:8080/images/icons/issuetypes/defect.png","selected":false},{"label":"Operation","value":"10300","icon":"http://ybsxw296:8080/images/icons/issuetypes/task_agile.png","selected":false},{"label":"Tech Support","value":"10301","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11115&avatarType=issuetype","selected":false},{"label":"SD Deliverable Task","value":"10302","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11118&avatarType=issuetype","selected":false},{"label":"Recruitment","value":"10304","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11111&avatarType=issuetype","selected":false},{"label":"Onboarding","value":"10306","icon":"http://ybsxw296:8080/images/icons/issuetypes/task_agile.png","selected":false},{"label":"Pipeline","value":"10309","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Immediate Demand","value":"10310","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11115&avatarType=issuetype","selected":false},{"label":"Skills Matrix","value":"10311","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Training","value":"10312","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Cross site move","value":"10313","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11110&avatarType=issuetype","selected":false},{"label":"Offsite meeting","value":"10314","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Renewal","value":"10315","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11114&avatarType=issuetype","selected":false},{"label":"Timesheet Management","value":"10316","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Offboarding","value":"10317","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"IT requests","value":"10318","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Sciforma Report","value":"10319","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Intra-site moves","value":"10320","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Floor plan maintenance","value":"10321","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Quality Control","value":"10322","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Mandatory Training","value":"10323","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Activity Management","value":"10324","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"MI Project","value":"10400","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Initiative","value":"10502","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11115&avatarType=issuetype","selected":false},{"label":"Request For Work","value":"10503","icon":"http://ybsxw296:8080/images/icons/issuetypes/task_agile.png","selected":false},{"label":"Ad-Hoc","value":"10504","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11116&avatarType=issuetype","selected":false},{"label":"3rd Party Suppliers","value":"10600","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"3rd Party On-boarding","value":"10702","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"3rd Party Off-boarding","value":"10703","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"3rd Party Renewal","value":"10704","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Engagement Template","value":"10705","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Query","value":"10706","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11120&avatarType=issuetype","selected":false},{"label":"Requirement","value":"10707","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11115&avatarType=issuetype","selected":false},{"label":"Sprint Defect","value":"10708","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11108&avatarType=issuetype","selected":false},{"label":"Support","value":"10709","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11109&avatarType=issuetype","selected":false},{"label":"Test case","value":"10710","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11106&avatarType=issuetype","selected":false},{"label":"UAT Defect","value":"10711","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11103&avatarType=issuetype","selected":false}]},{"label":"10310","items":[{"label":"Please select...","value":"","icon":null,"selected":false},{"label":"Story","value":"6","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Task","value":"3","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11118&avatarType=issuetype","selected":false},{"label":"Bug","value":"1","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11103&avatarType=issuetype","selected":false},{"label":"Tech Task","value":"10105","icon":"http://ybsxw296:8080/images/icons/issuetypes/defect.png","selected":false},{"label":"UX Task","value":"10104","icon":"http://ybsxw296:8080/images/icons/issuetypes/requirement.png","selected":false},{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false}]},{"label":"10920","items":[{"label":"Task","value":"3","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11118&avatarType=issuetype","selected":false},{"label":"Story","value":"6","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Bug","value":"1","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11103&avatarType=issuetype","selected":false},{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false}]},{"label":"10923","items":[{"label":"Please select...","value":"","icon":null,"selected":false},{"label":"Bug","value":"1","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11103&avatarType=issuetype","selected":false},{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false},{"label":"Improvement","value":"4","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11110&avatarType=issuetype","selected":true},{"label":"New Feature","value":"2","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11111&avatarType=issuetype","selected":false},{"label":"Story","value":"6","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false},{"label":"Task","value":"3","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11118&avatarType=issuetype","selected":false},{"label":"Requirement","value":"10707","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11115&avatarType=issuetype","selected":false}]},{"label":"10402","items":[{"label":"Please select...","value":"","icon":null,"selected":false},{"label":"Bug","value":"1","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11103&avatarType=issuetype","selected":false},{"label":"Epic","value":"10000","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11107&avatarType=issuetype","selected":false},{"label":"Story","value":"6","icon":"http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11100&avatarType=issuetype","selected":false}]}]"></div>
******** type="application/json" id="issuetype-projects">{"10301":"10304","10300":"10000","11000":"10923","10806":"10921","10502":"10402","11002":"10923","10205":"10310","11003":"10922","10700":"10402","10800":"10900","10000":"10000","10501":"10402","10803":"10918","10901":"10923","10600":"10402","10801":"10901","10804":"10919","10204":"10000","10203":"10304","11100":"11200","11004":"10923","10503":"10402","10304":"10401","10805":"10920","10402":"10516","11200":"11300","10201":"10301","10403":"10000","10702":"10402","10202":"10308","10404":"10522","10701":"10000","11005":"10923","11006":"10000","11007":"10923","11008":"10923","11009":"10923","11010":"10923","11011":"10923","11012":"10923"}*********>
******** type="application/json" id="issuetype-defaults">{"11200":"6","10304":"6","10401":"","10402":"","11300":"1","10308":"","10310":"","10918":"6","10919":"","10920":"6","10921":"6","10922":"","10923":"","10000":"","10900":"3","10516":"","10901":"","10522":"","10301":"5"}*********>
<div class="aui-ss issuetype-ss aui-ss-has-entity-icon" id="issuetype-single-select"><input autocomplete="off" role="combobox" aria-autocomplete="list" aria-haspopup="true" aria-expanded="false" class="text aui-ss-field ajs-dirty-warning-exempt" id="issuetype-field" type="text" aria-controls="issuetype-suggestions"><div class="aui-list" id="issuetype-suggestions" tabindex="-1" role="listbox"></div><span class="icon aui-ss-icon noloading drop-menu"><span>More</span></span><img class="aui-ss-entity-icon" alt="" src="http://ybsxw296:8080/secure/viewavatar?size=xsmall&avatarId=11110&avatarType=issuetype"></div>
<input autocomplete="off" role="combobox" aria-autocomplete="list" aria-haspopup="true" aria-expanded="false" class="text aui-ss-field ajs-dirty-warning-exempt" id="issuetype-field" type="text" aria-controls="issuetype-suggestions">
<div class="aui-list" id="issuetype-suggestions" tabindex="-1" role="listbox"></div>
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Selenium VBA - loop to align new data with old data in worksheet
Replies
8
Views
324
Anthony47
A
Y
  • Question Question
How to select Gender from Dropdown list using Excel VBA?
Replies
0
Views
651
YJones
Y
M
  • Solved
Excel VBA screen not updating after Wait function
Replies
1
Views
251
Michael36
M
D
  • Question Question
VBA + Excel or Webpage Screenshot along with DateTime stamp from task bar
Replies
0
Views
331
DDRO
D
B
  • Question Question
Trying to click a link in IE using VBA
Replies
0
Views
1K
Bak92
B

Forum statistics

Threads
1,223,228
Messages
6,170,876
Members
452,363
Latest member
merico17

Share this page

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