newline in a textbox vba

Where is the textbox located and how was it created?

If it's a textbox Shape on a worksheet you can just press ENTER to get a new line.

If it's an ActiveX textbox on a worksheet (or a textbox on a userform) set the MultiLine property to True and EnterKeyBehaviour to True and you can also use ENTER.

Hi,

I was thinking it was the Visual Basic constant of "vbCrLf" instead of "Newline" .

See http://www.programmersheaven.com/mb/...and-vbnewline/

It looks like either will work, depending on the platform.

See more about Visual Basic Constants at http://msdn.microsoft.com/en-US/libr...(v=vs.80).aspx