lab_harts
01-27-2019, 10:56 AM
Hi, sorry, my macro knowledge is below average...I have the following code in my macro:
.....
Dim drp As HTMLFormElement
Set drp = HTML.getElementById("sfield")
' THESE ARE THE VALUES <option value="centrename">Center Name</option>
' THESE ARE THE VALUES <option value="district">District</option>
' THESE ARE THE VALUES <option value="location">Location</option>
drp.SelectedIndex = 1
.....
what if I want to use the "text" value in searching? in this case, I want to use the word "district" in selecting, instead of 1?
I would really appreciate any help...tia.
.....
Dim drp As HTMLFormElement
Set drp = HTML.getElementById("sfield")
' THESE ARE THE VALUES <option value="centrename">Center Name</option>
' THESE ARE THE VALUES <option value="district">District</option>
' THESE ARE THE VALUES <option value="location">Location</option>
drp.SelectedIndex = 1
.....
what if I want to use the "text" value in searching? in this case, I want to use the word "district" in selecting, instead of 1?
I would really appreciate any help...tia.