text box pasting

[jonwhitehead]

is there any way to activate the right click paste function on a text box? also, when i paste html source code from a website into a cell, normally it spans several cells and appears as it was on the site (i.e. not as html code). however, when i paste the source code into a text box and then the text box places the html code into the same cell it appears as the source code itself, it does not span several cells and carriage returns in the html code appear as squares within the code now in the cell. is there anyway for me to enter the source code into the text box and have it appear the same way as if i paste it directly into the cell.

the reason im asking this is that im designing a macro that will put source code from different web pages (several columns of data on each page) on multiple sheets.

thanks
jon