Can I/How do I show a webpage in an excel form?

excel, vba

Solution

It is possible. You should use the `WebBrowser` control in your `Userform`.

In the VBE, go to `Tools`, then `Additional Controls`. Enable `Microsoft Web Browser`.

A new icon in your `Toolbox` should show up. It's the `WebBrowser` control. Add it to your userform.

Code is up to you. Sample follows:

Private Sub UserForm_Initialize()
    Me.WebBrowser1.Navigate "http://www.google.com"
End Sub

The above code navigates the control to Google when you start up the userform, like so:

Hope this helps.

Problem

I making a spreed sheet to evaluate user experience of a web page. I am wondering, can I have the user open a workbook, have a form pop-up show a webpage in one portion and have questions in another portion. The webpage has to be active and not an image. If it is doable, can I be provided direction in terms of another post or website? Thank you.

Original source