How do I select an option from a dropdown menu and update the webpage. Code:
then I navigate to a URL and I fetch the dropdown menu using html id and put value=my desired value
Please Login or Register to view this content.
I successfully get the option. But, the website doesn't update? e.g. filling up other fields.Please Login or Register to view this content.
I believe some javascript needs to be run. How can i fix this using VBA?
Source code for dropdown menu field:
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
As you are new I am adding it for you.Please read forum rules. Thanks
https://www.mrexcel.com/board/thread...ation.1129212/
Thank you! Great, I will keep this in mind going forward
After setting the dropdown option, you could try:
Can't guarantee it will work, depends on the site, and yes potentially you need to actually invoke a js function. Without the URL I can't suggest more, but try the above line, and hopefully it is that simple.Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
I tried the fireevent("onchange") but it didn't work.
To access the page here, a login is required that's why I can't share it. What to do?
I haven't experienced it myself, and can't say I see how it would make a difference, but I have read posts in the past where people first gave focus to the element to make it work. So it is a long shot, but you could try:
Without seeing the code behind the page I really can't guess more. (I do understand you can't share it)Please Login or Register to view this content.
Edit: for me it always works with brackets, but you could try removing the brackets around "onchange"
Last edited by Arkadi; 03-31-2020 at 02:16 PM.
Sourcode for dropdown:
<div class="rcbSlide" style="z-index: 6000; display: block; width: 206px; top: 235px; left: 412px; overflow:
visible;">
<div id="ctl00_MainContent_CreateWebForm__SubjectComboBox_ComboBox_DropDown"
class="RadComboBoxDropDown RadComboBoxDropDown_Telerik " style="width: 204px; display: block;
top: 0px; visibility: visible; transition: none 0s ease 0s;">
<div class="rcbScroll rcbWidth" style="height: 126px;">
<ul class="rcbList">
<li class="rcbHovered">Forespørgsel til Energinet</li>
<li class="rcbItem">Måledata</li>
<li class="rcbItem">Målepunkt eller ad hoc spørgsmål</li>
<li class="rcbItem">Orientering til alle</li>
<li class="rcbItem">Priser</li>
<li class="rcbItem">Pristilknytninger</li>
</ul>
</div>
</div>
</div>
I am doing this:
HTMLDoc.getElementById("ctl00_MainContent_CreateWebForm__SubjectComboBox_ComboBox_Arrow").Click
HTMLDoc.getElementById("ctl00_MainContent_CreateWebForm__SubjectComboBox_ComboBox_DropDown").Focus
'HTMLDoc.getElementById("ctl00_MainContent_CreateWebForm__SubjectComboBox_ComboBox_DropDown").Value = "Målepunkt eller ad hoc spørgsmål"
HTMLDoc.getElementById("ctl00_MainContent_CreateWebForm__SubjectComboBox_ComboBox_DropDown").FireEvent ("onchange")
The value part doesn't work as this is not an attribute. I think I need to go down the rcb list and select/click on item 3? How?
ctl00_MainContent_CreateWebForm__SubjectComboBox_ComboBox_Arrow is the arrow button to open the dropdown list.
I need to go down the dropdown list and select item 3 or click on item 3 - How may I do this?
Thanks in advance.
Added at the request of the OP by PLM :
This is the xpath alternative
Command = Click
xpath=//*[@id="ctl00_MainContent_CreateWebForm__SubjectComboBox_ComboBox_DropDown"]/div/ul/li[3]
This works but I need a VBA alternative to this - how can this be done in VBA?
Last edited by Pepe Le Mokko; 04-01-2020 at 06:26 AM. Reason: Added text to post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks