Hi I'm a Beginner when it comes to VBA,
i'm Trying to link a Webbrowser to search for address's in my excel workbook,
I have inserted the Active Webrowser window and worked out the hyperlink creator,
I have created a Command button to run the formula,
but i'm having trouble linking the two functions,
In VBA< under the commang button
I have this
Private Sub CommandButton1_Click()
WebBrowser1.Navigate2 Sheet6.Range("C8").Value
End Sub
C8 is the location of the hyperlink.
It comes up with a Runtime Error 5, Can some one tell me why this may occur?
Thanks for your help in advance.
i'm Trying to link a Webbrowser to search for address's in my excel workbook,
I have inserted the Active Webrowser window and worked out the hyperlink creator,
I have created a Command button to run the formula,
but i'm having trouble linking the two functions,
In VBA< under the commang button
I have this
Private Sub CommandButton1_Click()
WebBrowser1.Navigate2 Sheet6.Range("C8").Value
End Sub
C8 is the location of the hyperlink.
It comes up with a Runtime Error 5, Can some one tell me why this may occur?
Thanks for your help in advance.