Control in Excel 2007

[K]

In excel is there any control which match all four categories below
1 - control should not resize itself to the text size when text is
pasted into it from different source
2 - control should get scroll bars appear when text in it exceed in
size from control size
3 - when text is pasted in control then text should appear in same
format as it was in the source
4 - individual text should be formated if required in the control

I tried
TextBox (Active X control)
TextBox (Drawing Tool)
Word Document Object

but it wont match all four categories mensioned above. Please can any
friend have any suggestions

 

[Joel]

Have you tried a WORDPAD Application?

windir = Environ("windir")
RetVal = Shell(windir & "\" & "wordpad.exe")


You may have to search for the wordpad application. the PC I'm using
doesn't have it in the normal location.

 

[K]

Have you tried a WORDPAD Application?

windir = Environ("windir")
RetVal = Shell(windir & "\" & "wordpad.exe")

You may have to search for the wordpad application.  the PC I'm using
doesn't have it in the normal location.







- Show quoted text -

thanks for replying. yes i have wordpad but i dont need any
application as i am looking for built in controls in excel like Active
X controls or Forms controls