ActiveX spreadsheet control problem

's Computer Specifications

Hi!

Is it possible to assign cell in a spreadsheet control on a userform as
multi line?
I tried several times to copy multi line strings into a spreadsheet control
but it was always converged into one line.

appreciate your help!

Eli

's Computer Specifications

Try with some text in cell A1

Range("A1").WrapText = True

--
Jacob

"אלי" wrote:

> Hi!
>
> Is it possible to assign cell in a spreadsheet control on a userform as
> multi line?
> I tried several times to copy multi line strings into a spreadsheet control
> but it was always converged into one line.
>
> appreciate your help!
>
> Eli

's Computer Specifications

Jacob,

Unfortunately I got the error "Method or data member not found"

Eli

"Jacob Skaria" wrote:

> Try with some text in cell A1
>
> Range("A1").WrapText = True
>
> --
> Jacob
>
>
> "אלי" wrote:
>
> > Hi!
> >
> > Is it possible to assign cell in a spreadsheet control on a userform as
> > multi line?
> > I tried several times to copy multi line strings into a spreadsheet control
> > but it was always converged into one line.
> >
> > appreciate your help!
> >
> > Eli

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Where is the ActiveX Spreadsheet control?	GadyC	Microsoft Excel Programming	0	30th Dec 2009 01:43 PM
How to lock an ActiveX Control box on the spreadsheet?	Ange	Microsoft Excel Worksheet Functions	1	29th Oct 2008 12:31 AM
Does ActiveX control on spreadsheet exist?	=?Utf-8?B?cXVhcnR6?=	Microsoft Excel Programming	3	12th Apr 2005 02:48 PM
Cannot view ActiveX spreadsheet control on IE	June Moore	Windows XP Internet Explorer	1	21st Sep 2004 03:15 AM
Using the Microsoft Spreadsheet Control as ActiveX	Lawrence	Microsoft Excel Programming	3	12th Nov 2003 03:56 PM