Transfer from userform into same cell but below other information

  • Hi,


    I have a Userform that transfers information from three text boxes into the same cell,



    Code
    1. Cells(emptyRow, 7).Value = LikePre.Value & "x" & ConPre.Value & PreResult.Value


    What I would like to be able to do is the final part of the code still gets added to the same cell but as a new line within the cell so it appears below the rest of the information.


    I guess im trying to make the cell multiline but I cant find anything that allows me to do that in VBA.


    Anyone know if this is possible?


    Thanks in advance

  • Re: Transfer from userform into same cell but below other information


    Code
    1. Cells(emptyRow, 7).Value = Cells(EmptyRow.Value) & Chr(10) & LikePre.Value & "x" & ConPre.Value & PreResult.Value
  • Re: Transfer from userform into same cell but below other information


    Hi thanks for this,


    This come up with a compile error - Invalid Qualifier for the following part,


    = Cell(emptyrow.value)


    Any ideas?


    Thanks

  • Re: Transfer from userform into same cell but below other information


    Easy enough to figure out - Forgot the ,7 when I typed it...

    Code
    1. Cells(emptyRow, 7).Value = Cells(EmptyRow.Value, 7) & Chr(10) & LikePre.Value & "x" & ConPre.Value & PreResult.Value
  • Re: Transfer from userform into same cell but below other information


    Yeah I tried that as I thought I could be that but it still does the same.


    It highlights the second emptyrow in the line and gives the same error?

  • Re: Transfer from userform into same cell but below other information


    Just figured it out,


    Code
    1. Cells(emptyRow, 7).Value = Cells(emptyRow, 7).Value & Chr(10) & LikePre.Value & "x" & ConPre.Value & PreResult.Value


    Thanks for your help wouldn't of got there without it.