• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • Last Modified:

multiline textbox and excel cell

hi all
i have a simple yet complicated question . it concerns the multiligne property of a textbox. here it is my problem:
i have a text65(it is a text box that has the option multiline set to true) and i want to transfert the content( which can be from 3 to 10 lines separated by enter) to a cell from excell sheet. now the thing that i cant make work is :
when i transfet it with this line:
it does it but it puts it in one cell which means that the cell becomes huge and compact and i cant make much sens of it . what i want it to do is to start writeing from that specific cell but not to put it in one cell and to make it available over multiple cells so that it appears as a normal text line.
thank you
  • 2
1 Solution
I think this should work:

dim arrayoftext() as string

arrayoftext() = split(text6,vbcrlf)

for x=0 to ubound(arrayoftext())
   .cell(4,x+5).value = arrayoftext(x)

if you need any of that explaining, just ask.

hope that helps


arrayoftext() = split(text6,vbcrlf)
 should be:
arrayoftext() = split(text65,vbcrlf)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now