| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX spreadsheet control problem
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveX spreadsheet control problem
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveX spreadsheet control problem
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveX spreadsheet control problem
Eli, If you fixed your problem, could you please forward me the solution? I'm trying to figure out how to reference a cel inside a spreadsheeet control, and I think your solution would help me. Thanks. --elizabeth אלי;598491 Wrote: 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 -- baker_eliz ------------------------------------------------------------------------ baker_eliz's Profile: http://www.thecodecage.com/forumz/member.php?u=1947 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=165847 http://www.thecodecage.com/forumz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to lock an ActiveX Control box on the spreadsheet? | Excel Worksheet Functions | |||
| Problem with ActiveX control | Excel Programming | |||
| Spreadsheet ActiveX control help file | Excel Programming | |||
| Does ActiveX control on spreadsheet exist? | Excel Programming | |||
| Using the Microsoft Spreadsheet Control as ActiveX | Excel Programming | |||
Hybrid Mode
