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,

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

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

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,

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.