Groups > microsoft.public.excel.programming > #108751

Embed drawing toolbar textbox or word doc in sheet, how to refer to it?

From	Mike S <mscir@yahoo.com>
Newsgroups	microsoft.public.excel.programming
Subject	Embed drawing toolbar textbox or word doc in sheet, how to refer to it?
Date	2016-04-15 16:40 -0700
Organization	A noiseless patient Spider
Message-ID	<nertvh$ov7$1@dont-email.me> (permalink)

Show all headers | View raw

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

Back to microsoft.public.excel.programming | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Embed drawing toolbar textbox or word doc in sheet, how to refer to it? Mike S <mscir@yahoo.com> - 2016-04-15 16:40 -0700
  Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? GS <gs@v.invalid> - 2016-04-15 21:07 -0400
    Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? Mike S <mscir@yahoo.com> - 2016-04-15 22:37 -0700
      Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? GS <gs@v.invalid> - 2016-04-16 02:01 -0400
        Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? Mike S <mscir@yahoo.com> - 2016-04-15 23:39 -0700
          Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? GS <gs@v.invalid> - 2016-04-16 06:34 -0400
  Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? GS <gs@v.invalid> - 2016-04-16 07:21 -0400
    Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? Mike S <mscir@yahoo.com> - 2016-04-16 22:14 -0700

csiph-web