On 4/16/2016 4:21 AM, GS wrote:
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?

Most controls include a properties dialog and/or userguide (hlp file) i
addition to what lists in the Properties window.

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

Set the Scrollbars property to suit...

0 = rtfNone
1 = rtfHorizontal
2 = rtfVertical
3 = rtfBoth

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.

Only VB6 thing I miss is the ability to use control arrays. One
advantage I like is that chk/opt controls can be grouped outside of (or
without) a container via their GroupName property.

FWIW
It's a bit of a chore getting userforms to display min/max controls and
make them resizeable, but still doable nevertheless. (Once done, the
form is reusable thereafter via 'Import...'!)

Making inter-dependant dropdowns via formulas on a worksheet is easier
than doing same on a form which requires having to code. Worksheet
dropdowns have data validation; userform dropdowns require code for this.

Cells can be disguised to look/feel/act like btn/chk/opt controls quite
easily so they scroll/position properly when rows/cols visibility is
toggled. Event code handles this quite easily! Adjacent cell content can
auto-change via formulas depending on chk/opt cell choices.

Worksheet forms can be as interactive as you want, and are much easier
to scroll/use than a long userform! Using 'helper' cols/rows outside the
form area is a big bonus as these can be hidden at runtime. You can also
toggle display of col/row headers and gridlines so your worksheet
doesn't look like a worksheet.

HTH

Thank you for all of your thoughts... time to dig into this now.

Best Regards,
Mike