I'm wanting to add a Rich Textbox to my Excel sheet. I found this, but
don't know what to do from here.
http://msdn2.microsoft.com/library/7...us,vs.80).aspx

I have a simple textbox control on my sheet but I'd like to add some
formatting so my thought was a Rich Textbox. If there is a different
solution I'm open to that as well.

Use a textbox from the Drawing toolbar. It supports richtext formatting and
it is native to Excel.

--
Regards,
Tom Ogilvy


"M.Siler" wrote in message
...
I'm wanting to add a Rich Textbox to my Excel sheet. I found this, but
don't know what to do from here.
http://msdn2.microsoft.com/library/7...us,vs.80).aspx

I have a simple textbox control on my sheet but I'd like to add some
formatting so my thought was a Rich Textbox. If there is a different
solution I'm open to that as well.

Hi M-

What you have 'found' is something called in VBA procedures, not something
you simply draw on a spreadsheet.

Text boxes created using the Text Box tool can be formatted just about any
way you wish... Font, Font Size, Font Color, Text Alignment (Horizontal &
Vertical) Fill Color, Line Color, Line Style, 3D Effects, etc. etc. etc. Just
select the Text Box and change the settings using the Formatting & Drawing
toolbars or right-click the text box and choose Format Text Box. You can even
select portions of the text in the box and format it differently that the
rest.

If these capabilities aren't sufficient, please state what type of
'formatting' you need to do.

HTH |:)

"M.Siler" wrote:

I'm wanting to add a Rich Textbox to my Excel sheet. I found this, but
don't know what to do from here.
http://msdn2.microsoft.com/library/7...us,vs.80).aspx

I have a simple textbox control on my sheet but I'd like to add some
formatting so my thought was a Rich Textbox. If there is a different
solution I'm open to that as well.

Perhaps I'm not using the correct Text Box control. When I select the
control the forumal line looks like =EMBED("Forms.TextBox.1","") Then with
the control selected I right click and only see "Format Control..." and not
the "Format Text Box" you referenced. I'm using Excel 2003.

"CyberTaz" wrote in message
...
Hi M-

What you have 'found' is something called in VBA procedures, not something
you simply draw on a spreadsheet.

Text boxes created using the Text Box tool can be formatted just about any
way you wish... Font, Font Size, Font Color, Text Alignment (Horizontal &
Vertical) Fill Color, Line Color, Line Style, 3D Effects, etc. etc. etc.
Just
select the Text Box and change the settings using the Formatting & Drawing
toolbars or right-click the text box and choose Format Text Box. You can
even
select portions of the text in the box and format it differently that the
rest.

If these capabilities aren't sufficient, please state what type of
'formatting' you need to do.

HTH |:)

"M.Siler" wrote:

I'm wanting to add a Rich Textbox to my Excel sheet. I found this, but
don't know what to do from here.
http://msdn2.microsoft.com/library/7...us,vs.80).aspx

I have a simple textbox control on my sheet but I'd like to add some
formatting so my thought was a Rich Textbox. If there is a different
solution I'm open to that as well.