Hi,
I am making a stock quote list in an Excel spreadsheet. I used your tutorial* to enter the first stock price in an excel cell and it worked! (I changed the stock price to appear in cell A1 instead of a message box) However, at the moment I do only have 1 stock price and my goal is to make a list of stock prices which I can update by just running the macro once.
What do I have to change to get not only 1 stock price, but multiple imported at once?
(I have no VBA coding experience, but know how to do minor changes to the code)
Thanks in advance,
Tom
* https://www.teachexcel.com/excel-tutorial/2189/vba-macro-to-import-web-data-into-excel?nav=yt