A Internet Explorer withing a spreadsheet!

[hey yer barred]

Hi All!

I have been set a challage to make a internet explorer within a spreadsheet...is this possible?

I want a address bar, a simple box which will dislplay the page and a go button!

Please can you post the coding as I like to type the coding myself, this way i learn more!

Please help me!

 

[Norie]

Why not just display the built-in Web toolbar?

 

[hey yer barred]

You'd think that, but that is classed as cheating!

Its like a challage to see who can make the best lookin one...so i need a explorer within a spreadsheet!

 

[Norie]

Well I would suggest you look at the WebBrowser control.

Or would that be cheating too?

 

[hey yer barred]

I dont know!
Basically, i want the user to enter the web address into cell A1 and clcik go (button)

When they do that, in cell B3, which will be merged to make it bigger, the website will appear

 

[Norie]

So why do you need an explorer in a spreadsheet?

Can't you just use a hyperlink and/or FollowHyperlink?

PS If you don't know what you want/need it's kind of hard to help, since neither do we.

 

[hey yer barred]

I want the user to put in the web address in cell A2, and when they click go the internet page will appear in cell B2...which will be made larger to display the page

 

[royUK]

I want the user to put in the web address in cell A2, and when they click go the internet page will appear in cell B2...which will be made larger to display the page

AFAIK, you can't display a web page in a cell!

As Norie says it is quite simple to use the cell's value to open a web page using IE, or more difficult would be using a WebBrowser control.

There's some code in the Hyperlink in a UserForm example that you could adapt

http://www.excel-it.com/vba_examples.htm