Using VBA to pull data from a youtube search (HTML)

Hello! I am new to VBA, and I am having a hard time figuring out how to move forward with this code that I am working on. I have excel set up to create a custom search URL based on what I am looking for, and I have that in cell(2,2). I have my code set up to use that search URL, but I can't figure out how to pull the links I need (they are all tagged with "href" in the HTML code) and put them in a column back in my excel sheet. Below is my code thus far, any suggestions?

Please Login or Register  to view this content.

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Hello again! Think that I am making a little progress, but I'm still having trouble. I need help to parse the strings from the HTML code and writing to them to cells via VBA code. I am looking to create a list of youtube channels based on my search. I can get IE to open to the page I want, but I cannot pull the channel names and place them in a list in my workbook.

It seems that my getelementsbytagname operation keeps having issues.

Would someone be able to give me some direction on how to create said list?

Here is my code:

Please Login or Register  to view this content.