TextBox and Multipage with Webcontrol on Userform in Excel

[sanits591]

Hi,

I have a Userform with following controls pasted on it:
1. One Textbox on Userform
2. One Multipage control (p) on Userfrom, with 5 pages.
3. 2 Webcontrols on Multipage of page1

Now the problem is, as soon as i type in the textbox then webcontrol on p gets the required webpage according to the textbox, but as soon as i come back from page2 of p and then click on the textbox the error comes.

Here, below, i am giving the code for the same, requesting to guide, how to get rid of the errors.

Private Sub TextBox1_Change()

Dim strURL As String
    
If Me.MultiPage1.SelectedItem.Index = 0 Then
    If TextBox1.Text <> "" Then
    strURL = "http://a" & Me.TextBox1.Text
        Me.WebBrowser1.Navigate strURL
        Me.WebBrowser2.Navigate strURL
    End If
    
ElseIf Me.MultiPage1.SelectedItem.Index = 1 Then
    MsgBox "2nd page selected"
End If

End Sub

Thanks!

 

[sanits591]

Help from someone on this.

 

[sanits591]

Please help!

 

[RoryA]

It's very hard to troubleshoot if you don't tell us what error you are getting and on which line of code.
Also, I would suggest not using the Change event, since that is triggered with every keystroke in the textbox.

 

[sanits591]

Thanks! for responding to it!. I get an error,

"Run time error '-2147467259 (80004005)':
Method navigate of object 'IWebbrowser2' failed.

This error comes in Me.WebBrowser1.Navigate strURL

Request to assist on this.

 

[RoryA]

That would imply that the URL is invalid. Not really surprising if you try and navigate on every keypress...

 

[p45cal]

rorya, it's a bit more than that; the webbrowswer seems to disappear once you've clicked to another page and back. I played with this but got nowhere (hence no posting from me on this). If you move one of the webbrowsers off the multipage control directly onto the userform, that one works, the one on the multipage doesn't. I googled and found several people had had the same experience, but no-one had come up with a solution, only workarounds, mostly involving ditching the multipage. The problem persists in Excel 2010.

 

[RoryA]

You're quite right. Apologies - I should have tested first.
In reality that doesn't surprise me particularly since the multipage has never worked well with non-MSForms controls (e.g. the RefEdit). I suspect that using a TabStrip might be the easiest option if the effect of a multipage is required.

 

[sanits591]

I used the TabStrip also, but there is another kind of problem.

Request to see the link.
http://www.mrexcel.com/forum/showthread.php?t=579548