Rich Text box

[GS80]

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

 

[Rick Rothstein \(MVP - VB\)]

You may this recent discussion of some interest...

http://groups.google.com/group/micr...336ba7114fb7?hl=en&lnk=st&q=#f906336ba7114fb7

Rick

 

[Peter T]

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]

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]

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/mi...l=en&lnk=gst&q=russian-dolls#13b649c569bb5369

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