Thread: Rich Text box
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Rich Text box

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