better than a textbox? mini-wordprocessor?

[ChgsAllAround]

My users have a document in Excel that needs to have free-form text cells (up to 10) which might include bold, italic, bullets, paragraphs and tabs. I want to restrict them to a pre-defined size--I don't want the exterior dimensions to increase, although scroll bars would be ok.

A Textbox from the draw menu allows for most of my needs, but text that is too long for the size of the box can only be seen using arrows to navigate inside the box.

A Textbox in a form does not allow ANY formatting (bold, etc) I've tried to find a mini wordprocessor that someone may have created in script, but no luck with that.

An embedded Word object seems like a possibility, but it resizes the box when you leave the object for the size of its contents, which overwrites other cells.

I would like to possibly embed a Word object inside a form and then place the contents of the embedded object into a regular cell after hiding the form. I can't find anything on an embedded object inside a form.

Can anyone help or does anyone have a different suggestion?
Thanks

 

[EugeneCarter]

What about embedding the word document as an icon, and then format that object to fit inside the cell, and set its properties to move & size with the cell?

 

[ChgsAllAround]

Eugene,
I may be misunderstanding you, but are you saying to just have the generic icon that must be dbl-clicked to see content? Is that is what you meant, they will want to see the text at all times, so an icon won't really work for this purpose. If you are meaning some way to turn the text into a picture that can shrink and grow but still be readable, please tell me more.
Thank you

 

[EugeneCarter]

I've experimented, and based on each of the desired features, the best I can come up with is the fixed size of text boxes / rectangles, which you can probably adjust the font on, if the contents was over a certain size to "shrink it"
Otherwise, you'll end up concealing data, restricting formating, etc.

 

[ChgsAllAround]

Thanks. I'm actually surprised that no one has created a macro for what would be the equivalent of a mini-word processor...it would take more time right now than I can allow, but I'm OC enough to want to spend the time to do enough character trapping to create one.