Embed text file in excel

[MetLife]

Hi,

I have a text file & want to put this in my workbook.

At first I created a "Text Box" in excel and copied the information from the external text file to the internal "Text Box".

This is OK but the annoying thing is that there is no scroll bar on the right, so since the text is long it is difficult to navigate around the "Text Box".

Is there anyway to embed the entire text file, or add a scroll bar to the "Text Box"? I really just need a solution that will allow me to conveniently navigate through the text.

Can you let me know if there is a good solution?

Thanks

 

[lhartono]

Goto Design Mode, Open Properties Window, change "Multiline" : True, change "Scrollbars" : "3 - fmScrollBarsBoth"

 

[MetLife]

Goto Design Mode, Open Properties Window, change "Multiline" : True, change "Scrollbars" : "3 - fmScrollBarsBoth"

Where is design mode? Is this somewhere in excel?

Thanks