My program requires the user to copy numbers to a UserForm from an Internet
Explorer page. I was able to resize the IE to half of my screen. Is there a
way to keep IE on top of the Form while the user still can edit the Form so
that the user does not have to switch back and forth between two applications?

Thanks.

How about including a webbrowser onto the userform itself:
http://www.dailydoseofexcel.com/arch...owser-control/

HTH. Best wishes Harald

"Scott" skrev i melding
...
My program requires the user to copy numbers to a UserForm from an
Internet
Explorer page. I was able to resize the IE to half of my screen. Is there
a
way to keep IE on top of the Form while the user still can edit the Form
so
that the user does not have to switch back and forth between two
applications?

Thanks.

Thanks for the help.

It is a nice function. It works when I test it. However, my form
automatically maximizes to fit the screen once launched. Then the WebBrowser
window disappeared from the form and when I tried to activate the function,
it gave a "Run-time error" and "Method 'Navigate2' of object 'IWebBrowser2'
failed." It worked only after I disabled the form's maximizing function.

"Harald Staff" wrote:

How about including a webbrowser onto the userform itself:
http://www.dailydoseofexcel.com/arch...owser-control/

HTH. Best wishes Harald

"Scott" skrev i melding
...
My program requires the user to copy numbers to a UserForm from an
Internet
Explorer page. I was able to resize the IE to half of my screen. Is there
a
way to keep IE on top of the Form while the user still can edit the Form
so
that the user does not have to switch back and forth between two
applications?

Thanks.

It seems that I can only access the page (of the form) containing WebBrowser
once. If I then go to other pages and come back, the WebBrower window is
gone even though I never ran the function. If I try to run the function, it
gives the error message cited in my last email.

"Scott" wrote:

Thanks for the help.

It is a nice function. It works when I test it. However, my form
automatically maximizes to fit the screen once launched. Then the WebBrowser
window disappeared from the form and when I tried to activate the function,
it gave a "Run-time error" and "Method 'Navigate2' of object 'IWebBrowser2'
failed." It worked only after I disabled the form's maximizing function.

"Harald Staff" wrote:

How about including a webbrowser onto the userform itself:
http://www.dailydoseofexcel.com/arch...owser-control/

HTH. Best wishes Harald

"Scott" skrev i melding
...
My program requires the user to copy numbers to a UserForm from an
Internet
Explorer page. I was able to resize the IE to half of my screen. Is there
a
way to keep IE on top of the Form while the user still can edit the Form
so
that the user does not have to switch back and forth between two
applications?

Thanks.

You lost me man. Your userform has pages, what kind of pages ? How does it
automatically resize ? What is the function in mention ? Need code and
detail to assist further, sorry.

Best wishes Harald

"Scott" skrev i melding
...
It seems that I can only access the page (of the form) containing
WebBrowser
once. If I then go to other pages and come back, the WebBrower window is
gone even though I never ran the function. If I try to run the function,
it
gives the error message cited in my last email.

Here is what happened. I created a UserForm1. Then I put a MultiPage
control on UserForm1. By default (on my computer), the MultiPage has two
pages, Page1 and Page2. I put a WebBrowser control on Page1. That's it.
There are no codes and no other controls. After I click the Run button, the
UserForm1 shows Page1 with a white box, which is supposed to show IE if I
have right codes, right? However, when I click Page2 and then come back to
Page1, the white box on Page1 is gone. If the white box, or WebBrowser,
disappears, how IE information could be shown? That is the problem with my
program. It worked on the first time but not the second time if I left the
page and came back to it.

Thanks for help.


"Harald Staff" wrote:

You lost me man. Your userform has pages, what kind of pages ? How does it
automatically resize ? What is the function in mention ? Need code and
detail to assist further, sorry.

Best wishes Harald

"Scott" skrev i melding
...
It seems that I can only access the page (of the form) containing
WebBrowser
once. If I then go to other pages and come back, the WebBrower window is
gone even though I never ran the function. If I try to run the function,
it
gives the error message cited in my last email.

Wow, you're right. I produce other unpleasant behavior too with a webbrowser
on a multipage. I can't say anything but "do not put it on a multipage and
hopefully an MVP can dig up an explanation.

Can you use a tabstrip instead and place the other stuff in frames ? (except
for the webbrowser, it seem to behaves just as volatile there). Something
like

Private Sub TabStrip1_Change()
Select Case TabStrip1.Value
Case 0
WebBrowser1.Visible = True
Frame2.Visible = False
Case 1
WebBrowser1.Visible = False
Frame2.Visible = True
Case Else
End Select
End Sub

Best wishes Harald

"Scott" skrev i melding
...
Here is what happened. I created a UserForm1. Then I put a MultiPage
control on UserForm1. By default (on my computer), the MultiPage has two
pages, Page1 and Page2. I put a WebBrowser control on Page1. That's it.
There are no codes and no other controls. After I click the Run button,
the
UserForm1 shows Page1 with a white box, which is supposed to show IE if I
have right codes, right? However, when I click Page2 and then come back
to
Page1, the white box on Page1 is gone. If the white box, or WebBrowser,
disappears, how IE information could be shown? That is the problem with
my
program. It worked on the first time but not the second time if I left
the
page and came back to it.

Thanks for help.


"Harald Staff" wrote:

You lost me man. Your userform has pages, what kind of pages ? How does
it
automatically resize ? What is the function in mention ? Need code and
detail to assist further, sorry.

Best wishes Harald

"Scott" skrev i melding
...
It seems that I can only access the page (of the form) containing
WebBrowser
once. If I then go to other pages and come back, the WebBrower window
is
gone even though I never ran the function. If I try to run the
function,
it
gives the error message cited in my last email.

Thank you very much. I'll try this though I've never used TabStrips.

"Harald Staff" wrote:

Wow, you're right. I produce other unpleasant behavior too with a webbrowser
on a multipage. I can't say anything but "do not put it on a multipage and
hopefully an MVP can dig up an explanation.

Can you use a tabstrip instead and place the other stuff in frames ? (except
for the webbrowser, it seem to behaves just as volatile there). Something
like

Private Sub TabStrip1_Change()
Select Case TabStrip1.Value
Case 0
WebBrowser1.Visible = True
Frame2.Visible = False
Case 1
WebBrowser1.Visible = False
Frame2.Visible = True
Case Else
End Select
End Sub

Best wishes Harald

"Scott" skrev i melding
...
Here is what happened. I created a UserForm1. Then I put a MultiPage
control on UserForm1. By default (on my computer), the MultiPage has two
pages, Page1 and Page2. I put a WebBrowser control on Page1. That's it.
There are no codes and no other controls. After I click the Run button,
the
UserForm1 shows Page1 with a white box, which is supposed to show IE if I
have right codes, right? However, when I click Page2 and then come back
to
Page1, the white box on Page1 is gone. If the white box, or WebBrowser,
disappears, how IE information could be shown? That is the problem with
my
program. It worked on the first time but not the second time if I left
the
page and came back to it.

Thanks for help.


"Harald Staff" wrote:

You lost me man. Your userform has pages, what kind of pages ? How does
it
automatically resize ? What is the function in mention ? Need code and
detail to assist further, sorry.

Best wishes Harald

"Scott" skrev i melding
...
It seems that I can only access the page (of the form) containing
WebBrowser
once. If I then go to other pages and come back, the WebBrower window
is
gone even though I never ran the function. If I try to run the
function,
it
gives the error message cited in my last email.