TimeFrame = Worksheets("Selector").Range("B1").Value 
   TimeFrame2 = CStr(TimeFrame)
    
    'HTMLDoc.querySelector("[name=AheadHour] option[value='8']").Selected = True   '<< this works!
    
    'HTMLDoc.querySelector("[name=AheadHour] option[value='Timeframe2']").Selected = True  '<< this does not work!

Set htmlDoc = ie.document
TimeFrame = Worksheets("Selector").Range("B1").Value
TimeFrame2 = CStr(TimeFrame)

htmlDoc.querySelector("[name=AheadHour] option[value='" & TimeFrame2 & "'").Selected = True

相关问题

热门标签

---

Java JavaScript Python PHP C# Android Html jQuery C++ Css IOS MySQL NodeJS