View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
K[_2_] K[_2_] is offline
external usenet poster
 
Posts: 557
Default Word Document Object on excel Sheet

Thanks lot Peter for all your help , time and effort.
I havent achived what I am tring to achive.
Actually I created macro to send email to lot of people from excel and
I got (Active X control) TextBox in which I put text which I want to
appear in email body. What I do for that TextBox is perfect as I can
enable Multiline in it (which i needed as i copy text from different
source and paste it into TextBox) and also you can have scroll bars in
it but the only problem whith it is you can not format indivudal
text. Word doc object work greate but the only problem is that when i
paste text in it from different source it expands it self according to
the text size which i dont need and with TextBox in shapes when i copy
text in it then the text beomes merge and not appear as it in the
source. I need something which dont size itself to the text size and
have scroll bars and the text in it can be formated indivudaly. If
you have any suggestions please let me know. Thanks again for all
your help