Scrape data from table by appending text to link

[severus]

Hello Folks,


I'm new to excel and I was looking for vba code for pulling data from a table on a website.
I did manage to find a video on YouTube that came close to what I wanted but .due to my knowledge gap I couldnt accomplish what I really wanted to do .
It would be appreciated if anyone could help me code based on the below specification


Link to the video I found :Automated data scraping from websites into Excel - YouTube


Unlike the video,I have a userform, with a text box and a button. my intention is to append the value of the text box (mentioned in the video) to the link so that
in the event of a value being entered into the textbox and clicking the button, the link is appeded with the textbox value and link with the appended text is redirected to the
desired page on the site.and once that has been accomplished, the table should be copied on to the excel sheet where I can perform the necessary manipulation.


Also I wanted to know whether it is possible to copy multiple lines in a column to a multiline texbox.




All help is deeply appreciated.


Regards
Severus