Get Data from MsgBox into a cell

[chrisellis250]

Hello,

This code works perfectly to scrape data from a website and it shows it via a msgbox:

Please Login or Register  to view this content.

However, after testing I would now like the data from my Msgbox to go into a cell on my worksheet. How would I go about doing this?

[Zer0Cool]

Just store what the message box was passed in variable instead and then set that variable as the value of the range object representing the cell, or skip the variable and use what you passed the msgbox as the value of the range.

ie:

Please Login or Register  to view this content.

[chrisellis250]

Right ok. I have changed it to this, but getting no joy:

Please Login or Register  to view this content.