INSERT HTML

[verluc]

Is it possible to insert an HTML code in an Excel page?If so how can I do that.
(it is an HTML code that gives me a textboxscroll)
Thanks in advance

[Brian from Maui]

verluc,pm colo

[verluc]

On 2002-05-16 00:11, Brian from Maui wrote:
verluc,pm colo

What do you mean: pm colo ?

[Brian from Maui]

verluc,

Colo has some awesome html stuff you can use in Excel. Send him Private message
Brian

[ This Message was edited by: Brian from Maui on 2002-05-16 00:28 ]
http://www.mrexcel.com/board/viewtop...736&forum=10&7

[ This Message was edited by: Brian from Maui on 2002-05-16 00:30 ]
http://www.mrexcel.com/board/viewtop...11&forum=10&26

[ This Message was edited by: Brian from Maui on 2002-05-16 00:31 ]

[Colo]

Hi verluc,
You would like to paste WebBrowser on a sheet, don't you?
If so, it is possible if using "WebBrowser control".

How to add the WebBrowser control on a Sheet

1. In Excel open the form in Design view.
2. Right-click the menu bar and then click Control Toolbox.
3. In the toolbox, click the More Controls tool. A menu appears that lists all the registered ActiveX controls in your system.
4. On the menu of ActiveX controls, click Microsoft WebBrowser Control.
5. On the sheet, click where you want to place the control.
6. Move and size the control to the area you want to display

After this, for exsample, you can navigate url what you want.
You will need to change the url to full path of html file.

'Sheet module--------------------------------------------------

Private Sub Worksheet_Activate()

  WebBrowser1.Navigate2 "http://www.mrexcel.com/board/index.php"

End Sub

'---------------------------------------------------------------

verluc,pm colo

Brian! Thank you for introducing me.

[Colo]

Hi verluc,
I received the mail from you. Sorry, I misunderstood you.
How to put textbox with scrollbar is....

1. Open the form in Design view.
2. Right-click the menu bar and then click Control Toolbox.
3. In the toolbox, click the Textbox.
4. On the sheet, click where you want to place the textbox control
5. Move and size the control to the area you want to display

After this you need change the properties of text box as following.

• MultiLine = True
  EnterKeyBehavior = True
  ScrollBars = fmScrollBarsVertical

I'll emal a sample file to you later.