Wait for Specific Text to Load Using VBA Object "MSXML2.XMLHTTP.6.0" or Similar

[rippleman]

I have the following code using Internet Explorer which allows the page to load until the word "Fair Value" appears in the final HTML (which I then want to extract):

Please Login or Register  to view this content.

Since I believe that Internet Explorer will no longer be supported in Windows 11, can someone provide code that will mimic this functionality using "MSXML2.XMLHTTP.6.0"or similar in VBA?

I do have Selenium installed, so similar code for that would also be acceptable.

The idea is that it is a dynamic page which takes a few seconds to completely load, so just getting the .responseText is not sufficient.

Thanks.