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

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" wrote:

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

On Jun 18, 1:46*pm, Joel wrote:
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" wrote:
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- Hide quoted text -

- 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