TextBox Text

K

K

Hi all, Is there some way to colour half of the text in TextBox
control or lets say if I select a text range intead of whole text in
TextBox then what macro code I need to colour that in to make that
text in bold.
 
P

Peter T

If you mean an ActiveX textbox on a sheet or userform, text characters
cannot be individually formatted (you can with a Forms textbox on a sheet)

Regards,
Peter T
 
K

K

How can I get Form TextBox as I am using excel 2007 and I got Form
TextBox icon in Developer section but I cant select it. Any
suggestions please
 
P

Peter T

Sorry I meant a textbox from the drawing toolbar in xl97-2003, or in 2007
Insert, Shapes, Basic shapes (top left in that section).

Look at textframe characters. From memory there's a relatively small maximum
number of characters you can format with mixed font formats, 255 or 1024 I
think. If writing text over 255 will need to add that in chunks of less than
255.

Trust you got your ole Word object to email

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign Formatted Block of Text to Theme 0
Is it possible to edit colours already saved as part of a custom theme? 0
Converting URLs in comments to Markdown-formatted links 2
How do I set focus (and select text) on a text box on a modeless userform? 0
Select Text to End of Footnote 9
DLookup in Continuous form 0
AppleScript - How do I select a text ? 1
Range headings 0

Top