Excel VBA Introduction Part 57.4 - Finding Web Elements in Selenium

By Andrew Gould

Chapters
00:00:00 Topic List
00:01:11 Navigating to a Web Page
00:03:39 Inspecting Elements
00:05:44 Finding an Element by ID
00:07:04 Applying Methods to an Element
00:07:37 Clicking a Button Element
00:09:13 Using a By Object
00:12:05 Checking If an Element is Present
00:14:15 Checking for the Presence of the Button
00:15:21 Finding an Element by Name
00:18:03 Finding Elements by Tag
00:20:36 Counting the Elements in a Collection
00:21:08 Checking If Any Elements Were Found
00:22:31 Referring to a Single Element by Index Number
00:23:35 Looping Through the Elements Collection
00:24:53 Using a For Each Loop
00:26:23 Finding Too Many Elements
00:29:09 Finding Elements within Another Element
00:30:56 Narrowing the Scope Further
00:33:49 Combining Methods in One Statement
00:35:53 Looping Through List Items
00:36:39 Finding Elements by Class
00:39:09 Using Multiple Class Names
00:40:50 Finding Elements by Link Text
00:43:20 Calculating the Link Text
00:44:52 Finding Elements by Partial Link Text
00:46:41 Introduction to CSS Selectors
00:49:02 Using CSS Selectors with IDs
00:51:08 CSS Selectors and By Objects
00:52:42 Using CSS Selectors with Names
00:54:55 Using CSS Selectors with Tags
00:56:37 Finding Multiple Types of Element
00:58:02 Narrowing Scope with CSS Selectors
00:59:45 Combining Options in a Single CSS Selector
01:03:17 More CSS Selectors (First of Type and nth of Type)
01:05:08 Using CSS Selectors with Class Names
01:05:54 Class Selectors on Specific Element Types
01:06:21 Multiple Classes with CSS Selectors
01:07:41 CSS Selectors for Link Text
01:10:42 Concatenating the CSS Selector
01:11:55 String Comparison Operators in CSS Selectors
01:13:16 Introduction to XPath
01:15:25 Using XPath with the ID Attribute
01:19:34 Using XPath with the Name Attribute
01:21:13 Using XPath with Tag Names
01:22:39 Finding Multiple Types of Element with XPath
01:23:23 Narrowing the Scope with XPath
01:26:12 Using XPath with Class Names
01:28:11 Multiple Class Names with XPath
01:29:15 Finding Links by Text with XPath

This video is a reference for the web element selection strategies in Selenium Basic. You'll learn how to refer to elements by ID, Name, Tag, Class, Link Text and Partial Link Text. You'll also learn the basics of writing CSS Selectors and XPath expressions.

[bencole]

I just finished re-watching this video to sharpen my VBA Selenium skills and it has helped me achieve nearly all of my goals from a project that I started on and off from about two years ago, and today I've nailed it 95% completed and just some tidying up of various untidy loops etc and committing it to a new Excel Workbook! My sense of achievement is sky high now and I literally could not have done this without your support Andrew. Thank you truly and now I'm off to watch the links you sent me regarding SQL!!! (-:

[mortimerconstant]

Hello, Andrew.
Great thanks for the quality of your videos and the time you spend to make them. More than useful, that help me a lot with VBA+Selenium, WebElements...
I like your pedagogic way to teach, step by step, insisting on importants words. Your precise way of talking allow to me to understand easier your words, as i speak a foreign language. I hope you will keep up this incredible work.Regards.

[rods]

Thanks for all these Selenium videos been trying various methods for loading into a excel sheet my youtube history and histroy comments for about 2 weeks, started watching your videos all done in 2 days thanks

[itsaustraliadayeveryday]

So good to hear a soft and pleasnt voice to explain all of this in such detail.
i could only but subscribe well done mate.

[bencole]

Thank you Andrew. That may very well have been the most useful video yet for me. I am gaining in confidence on this subject so much each day and you are the source of my knowledge and enjoyment. I find myself looking forward to the next video no sooner than the previous one has finished. Thank you once again and please keep up the phenomenal work you do.

[pauladams]

Most good YouTube videos are a team effort. Your (royal) training videos are the most useful I have ever seen, by far. I'm happy to support your class. The class structure is logical, progressive, and ties it all together in the end. The redrafting and work you put into each lesson is clearly impressive.

[MyAudioBookCompilation]

Really love this channel and of course our best teacher Mr. Andrew Gould.

[guguo]

Fantastic job Andrew! Thanks for your time to put together this informative video.

[ashishbaliyan]

sir what a nice explanation of getting web elements . i am sure nobody can find anywhere best tutorial about this .

[sidharthpattanayak]

Very nice video
Sir please make a video for handling alerts of the websites

[internationalpolitics]

You are the best teacher forever love the way you explain Thank you very much

[krn]

Thanks Andy. Just learned that the ID is case sensitive. Set SearchInput = <> Set SearchInput =

[markvalenzuela]

Thank you so much for this tutorials! hope we have an episode on how to download and save files from web using Selenium

[Damned]

I still push like and leave a comment because they say it helps YT algorithms understand what the world should see and value

[mayurchudasma]

Very useful video .
It will help us to develop some more skill

[this]

You all rule! I am nothing but a huge fan!

[dandanakan]

Dear Andrew, utterly perfect, thank you very much.

[lukereds]

Hi Andrew, i think i made a mistake deleting the previous message... anyway thank you, your answer was very correct!

[karnabudhathoki]

First viewer.... first commentator...I like wiseowl and Andrew Gould...

[frikduplessis]

Thank you Andrew for a great tutorial 👏👏👏👏