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