如何在VBA和webelement或selectelement中使用另外两个下拉动态？

Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
IE.Navigate "http://example.com" '替换为目标网页的URL

Do While IE.Busy Or IE.readyState <> 4
    DoEvents
Loop

Dim dropdown1 As Object
Set dropdown1 = IE.document.getElementById("dropdown1") '替换为第一个下拉框的ID或其他属性
dropdown1.Value = "选项1" '替换为要选择的选项的值

Do While dropdown1.Busy Or dropdown1.readyState <> "complete"
    DoEvents
Loop

Dim dropdown2 As Object
Set dropdown2 = IE.document.getElementById("dropdown2") '替换为第二个下拉框的ID或其他属性
dropdown2.Value = "选项2" '替换为要选择的选项的值

Do While dropdown2.Busy Or dropdown2.readyState <> "complete"
    DoEvents
Loop