I need to generate a report that will work in Excel 2000 and later, I'd
like to embed a rich textbox control (with scrollbars), or a Word
document if that isn't possible, where I can write the report and format
it.

I can embed a textbox control from the drawing toolbar or a word
document control in a worksheet, but I don't know how to refer to either
one of them to write text and format it inside them, where can I find
the name of the control so I can see the properties and work with it?

Also is there a way to get scrollbars to show on the rich textbox
control? I read that there was not.

And is there any advantage to doing this stuff in a form vs embedding
the control in a worksheet? The reports have to be both saved and
printed. It seems like that should be possible from the worksheet just
as easily as doing it with a form. I avoid Excel forms because they seem
clunky to work with after being spoiled working with VB6.

TIA,
Mike