#1   Report Post  
M.Siler
 
Posts: n/a
Default Rich Textbox

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/72z2h2cz(en-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.


  #2   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

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/72z2h2cz(en-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.




  #3   Report Post  
CyberTaz
 
Posts: n/a
Default

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/72z2h2cz(en-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.



  #4   Report Post  
M.Siler
 
Posts: n/a
Default

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/72z2h2cz(en-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.





  #5   Report Post  
CyberTaz
 
Posts: n/a
Default

Hello again-

That makes a difference - You are talking about the Text Box tool on the
Control Toolbox toolbar, which is a completely different matter. I had the
impression you were referring to the Text Box tool on the Drawing Toolbar.

Let's start over... Exactly what is it that you are using it for and what
type of formatting are you looking to 'add'?

Regards |:)


On 5/4/05 12:49 PM, in article ,
"M.Siler" wrote:

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/72z2h2cz(en-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.






--




  #6   Report Post  
M.Siler
 
Posts: n/a
Default

Oh, I see what you were talking about. That text box doesn't seem to have
scroll bars.

What I'm wanting to do is add some text (Cut-n-Paste from a web page),
formatted nicely color, font, bold, that permits someone to scroll through
it.

"CyberTaz" wrote in message ...
Hello again-

That makes a difference - You are talking about the Text Box tool on the
Control Toolbox toolbar, which is a completely different matter. I had the
impression you were referring to the Text Box tool on the Drawing Toolbar.

Let's start over... Exactly what is it that you are using it for and what
type of formatting are you looking to 'add'?

Regards |:)


On 5/4/05 12:49 PM, in article ,
"M.Siler" wrote:

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/72z2h2cz(en-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.






--




  #7   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

In the textbox from the drawing toolbar, you click in the text and use the
arrow keys to nagivate. You don't get scroll bars although you could put
scrollbars next to the textbox and perhaps write code to manage the
scrolling.

--
Regards,
Tom Ogilvy



"M.Siler" wrote in message
...
Oh, I see what you were talking about. That text box doesn't seem to have
scroll bars.

What I'm wanting to do is add some text (Cut-n-Paste from a web page),
formatted nicely color, font, bold, that permits someone to scroll through
it.

"CyberTaz" wrote in message

...
Hello again-

That makes a difference - You are talking about the Text Box tool on the
Control Toolbox toolbar, which is a completely different matter. I had

the
impression you were referring to the Text Box tool on the Drawing

Toolbar.

Let's start over... Exactly what is it that you are using it for and

what
type of formatting are you looking to 'add'?

Regards |:)


On 5/4/05 12:49 PM, in article ,
"M.Siler" wrote:

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/72z2h2cz(en-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.






--






  #8   Report Post  
CyberTaz
 
Posts: n/a
Default

In that case, you might want to do a bit of research into Active-X Controls.
There are literally hundreds of them and they all have their own special
capabilities... you can even have the website actually display as a navigable
object in your workbook. Just search the MS site or Google for Active-X.

On the simpler side, have you considered just creating hyperlinks to the
sites?

Regards |:)

"M.Siler" wrote:

Oh, I see what you were talking about. That text box doesn't seem to have
scroll bars.

What I'm wanting to do is add some text (Cut-n-Paste from a web page),
formatted nicely color, font, bold, that permits someone to scroll through
it.

"CyberTaz" wrote in message ...
Hello again-

That makes a difference - You are talking about the Text Box tool on the
Control Toolbox toolbar, which is a completely different matter. I had the
impression you were referring to the Text Box tool on the Drawing Toolbar.

Let's start over... Exactly what is it that you are using it for and what
type of formatting are you looking to 'add'?

Regards |:)


On 5/4/05 12:49 PM, in article ,
"M.Siler" wrote:

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/72z2h2cz(en-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.






--





  #9   Report Post  
M.Siler
 
Posts: n/a
Default

Yes, but sometime it might be viewed when there is no Internet connection.

Sure would be nice if MS would make the TextBox I'm using have the
formatting features of the Graphic TextBox.

The one I initially asked about
http://msdn2.microsoft.com/library/72z2h2cz(en-us,vs.80).aspx is that
something that would work and eveyone would have or would there have to be
something special installed on any PC that wanted to view the workbook?

"CyberTaz" wrote in message
...
In that case, you might want to do a bit of research into Active-X
Controls.
There are literally hundreds of them and they all have their own special
capabilities... you can even have the website actually display as a
navigable
object in your workbook. Just search the MS site or Google for Active-X.

On the simpler side, have you considered just creating hyperlinks to the
sites?

Regards |:)

"M.Siler" wrote:

Oh, I see what you were talking about. That text box doesn't seem to have
scroll bars.

What I'm wanting to do is add some text (Cut-n-Paste from a web page),
formatted nicely color, font, bold, that permits someone to scroll
through
it.

"CyberTaz" wrote in message
...
Hello again-

That makes a difference - You are talking about the Text Box tool on
the
Control Toolbox toolbar, which is a completely different matter. I had
the
impression you were referring to the Text Box tool on the Drawing
Toolbar.

Let's start over... Exactly what is it that you are using it for and
what
type of formatting are you looking to 'add'?

Regards |:)


On 5/4/05 12:49 PM, in article ,
"M.Siler" wrote:

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/72z2h2cz(en-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.






--







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract Data From Textbox SEA Excel Worksheet Functions 6 February 5th 09 09:21 PM
Textbox Greg Excel Discussion (Misc queries) 3 April 3rd 05 10:38 AM
Export TextBox contents to new workbook. Andy Tallent Excel Discussion (Misc queries) 0 February 22nd 05 02:49 PM
manipulating textbox in chart Peter Hafner Charts and Charting in Excel 0 January 31st 05 11:55 AM
Help needed with textbox formatting in Excel 2000 JIMBROOKS Excel Discussion (Misc queries) 1 January 1st 05 04:33 PM


All times are GMT +1. The time now is 09:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"