Hi
I have a Text box on my sheet as in sheet I have attached here with. I can format all text in text box (using properties). Is this possible to format some text as bold with different colour and other text using different formatting. I need a scroll bar as well. If it is not possible to do different formatting in a text box. I s any other alternative in excel. Thanks
Manvinder
To use scroll bars with a text box
Set Properties
Multiline > true
Scroll bars > Vertical
or
Multiline > False
Scroll bars > Horizontal
The scroll bars only appear when the text reaches a limit governed by the size of the text used and the size of the box itself.
You can't add formatting (bold, colour etc) to parts of your text, for that you need a RichTextBox, a VB control not available in VBA that I am aware of, I think it must be somewhere in 2003, but this is microsofts' evaluation of it
http://support.microsoft.com/kb/838010
Not very encouraging!...
Hope this helps
Last edited by Marcol; 07-20-2010 at 10:58 PM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks