Hi All,

Is it possible to insert a rich text boxinto an Excel worksheet? Preferably
i'd like to do this programatically however if it were possible to add one to
a spreadsheet i'm using as a template then that woulkd be a good start.

Any help is greatfully recieved.

Thanks in advance,

G

You may this recent discussion of some interest...

http://groups.google.com/group/micro...06336ba7114fb7

Rick


"GS80" wrote in message
...
Hi All,

Is it possible to insert a rich text boxinto an Excel worksheet?
Preferably
i'd like to do this programatically however if it were possible to add one
to
a spreadsheet i'm using as a template then that woulkd be a good start.

Any help is greatfully recieved.

Thanks in advance,

G

On a worksheet - why not use a Textbox from the Drawing toolbar. Unlike an
ActiveX textbox it can accept mixed font formats.

Regards,
Peter T

"GS80" wrote in message
...
Hi All,

Is it possible to insert a rich text boxinto an Excel worksheet?
Preferably
i'd like to do this programatically however if it were possible to add one
to
a spreadsheet i'm using as a template then that woulkd be a good start.

Any help is greatfully recieved.

Thanks in advance,

G

The problem i have is that the text is being written to a database via a
front end UI. The editor used stores the text in a varbinary(max) field in
the database. The output from the editor is in RTF format. I need to return
the varbinary text column and insert it into a text box so the format is
retained.

I'll try give it a shot but does it sound likely that a standard text box is
going to be able to handle this?


"Peter T" wrote:

On a worksheet - why not use a Textbox from the Drawing toolbar. Unlike an
ActiveX textbox it can accept mixed font formats.

Regards,
Peter T

"GS80" wrote in message
...
Hi All,

Is it possible to insert a rich text boxinto an Excel worksheet?
Preferably
i'd like to do this programatically however if it were possible to add one
to
a spreadsheet i'm using as a template then that woulkd be a good start.

Any help is greatfully recieved.

Thanks in advance,

G

Well there's no harm in trying the RTB. On the Controls toolbar click the
toolbox, select MS Rich Text Box and drag onto the sheet. If it sticks it
should work. If it doesn't it's most likely due to a security setting that
can be switched in the registry, I don't recall the particular key but see
links scattered in this discussion:

http://groups.google.co.uk/group/mic...b649c569bb5369

Once you've got it working in your system it should be fine, the main
problem though is if you want to distribute the file with the RTB.

Regards,
Peter T


"GS80" wrote in message
...
The problem i have is that the text is being written to a database via a
front end UI. The editor used stores the text in a varbinary(max) field in
the database. The output from the editor is in RTF format. I need to
return
the varbinary text column and insert it into a text box so the format is
retained.

I'll try give it a shot but does it sound likely that a standard text box
is
going to be able to handle this?


"Peter T" wrote:

On a worksheet - why not use a Textbox from the Drawing toolbar. Unlike
an
ActiveX textbox it can accept mixed font formats.

Regards,
Peter T

"GS80" wrote in message
...
Hi All,

Is it possible to insert a rich text boxinto an Excel worksheet?
Preferably
i'd like to do this programatically however if it were possible to add
one
to
a spreadsheet i'm using as a template then that woulkd be a good
start.

Any help is greatfully recieved.

Thanks in advance,

G