Excel VBA Introduction Part 57.7 - Using Select Drop Down Lists in Selenium

By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:

This video shows how to use Select and Option elements in Selenium for VBA to choose items from drop down lists on websites. You'll learn how to identify which type of drop down list you're working with and how to use the SelectElement class in Selenium to make working with drop down lists easy. You'll learn several ways to select an option from a select list and how to deal with cascading drop down lists. As a bonus, you'll learn how to download a file using a combination of Selenium and the URLDownloadToFile function.

Chapters
00:00 Topic list
00:35 Select Elements vs Other Drop Down Lists
03:48 Clicking the Accept Cookies Button
04:54 Referring to Select and Option Elements
07:45 Using the SelectElement Class
09:11 Referring to Items in the List
11:14 Selecting Options by Value or Text
13:12 Searching for Products
15:01 Writing Results to Excel
18:05 Cascading Drop Down Lists
21:37 Looping Through Options
24:31 Testing Whether to Select an Option
26:45 Testing if a Select Element is Visible
30:17 Listing Values in a Worksheet
33:04 Choosing Options Automatically
35:14 Clicking Buttons to Download Files
38:16 Getting the URL of a File
41:11 Downloading a File from a URL

[tejamarneni]

Thank you Andrew for the Amazing Video. Your videos are the best to learn VBA.

[lbarrera]

This is one of the best channels on vba, perhaps the best, THANK YOU VERY much. Please consider a video using selenium inside of a password protected site. I would love to learn how to print/download my bank statements programmatically

[KhalilYasser]

Thank you very much for these valuable videos.

[sidharthpattanayak]

Very nice video. Thank you for uploading

[ngohuunhan]

Thank you. Want see videos on part 57.x

[ronaldsiahaan]

Thank you Andrew, all your video is really usefull. I thoung most of all the audience will need to know how to change option value or text with selenium vba. Thanks in advance.

[jgcelis]

Hello Andrew, thank you for such educational videos. I have been trying to make my script work on a DIV that serves as a dropdown box using selenium (chrome) but I have not had any luck. Do you have a video that shows how to? You mentioned in the minute 2:35 that this particular video focuses on the "select" element but I would love to see how to go about selecting elements "wrapped" in a DIV and usually no ID or name. An example is this " <div class="zm-select-input"> "

Thank you!

[derekmoir]

thank you andrew your videos are brilliant they have helped me so much

do you have any other videos with regards dropdown lists ... having problems trying to click dropdown when its ul class and li class ?

[protostecnologia]

Wonderful videos, they are very useful. I have a trouble with a particular webpage in order to select an item in a drop down list. How can I show you the problem and ask you for help? Thank you very much. PD: ( I saw the videos referring an element on an option list), but i still without resolving my problem.

[DaInsighter]

Hello Andrew, your vba videos have help reignite my interest in learning excel vba.. thank you so much for your effort and passion to share knowledge

Therefore, I wonder if you will ever do a tutorial on selecting hidden elements on a webpage with selenium
It would be super helpful if there's a way around vba considering other languages can

[elricho]

excellent video, how do we wait for the site to finish loading the results, many times it gives an error because the server takes longer than it should

[ivankesaulya]

So, how do i code in <div element?

[naiduvikas]

Hello Andrew video's
I have small doubt about how to count a specific tag in a particaular div...?

[sidharthpattanayak]

What is the syntax ?
Storing of text of all options inside a combobox to a list quickly without using for each loop.

[huseyinyildiz]

How can I export the results at minute 7:51 to an excel sheet? What is the formula for this? Sheets1 A1

[sapisoftware]

Excellents videos of Selenium !! is any chance to run multithread with VBA? the same script running two or three at the same time. regards

[oholiab-song]

Hi Andrew. I am big fan of your tutorial and I just wonder if Chrome can handle the Frame structure coz in IE, to control the Frame Structure, I need to declare differently.

[drvinodgagrani]

Any video explaining automation of Select2 dropdown by vba

[gumshamohammed]

Hi, I loved your videos. Thank you so much for sharing an excellent knowledge.
I need help to write a code using selenium edge driver.
Using excel cell reference i have to select state, city and hospital and i want to download the specialities. Could you please help me to write code 🙏🙏🙏

[mathiyoogi]

Hi,

Thanks for the video.

Is there anyway to select from drop-down list without using selenium. I tried multiple times but still I am able to do that. The issue I am facing is, I am able the change the value in the select list but "on change" is not firing and the page is not loading with the selected value..please note there is no button to submit the changes by selecting the drop-down it should load the page