PDA

View Full Version : [SOLVED] Multiple Consecutive Line Feeds Using vbCrLf



zoom38
01-02-2018, 09:01 AM
Good morning, i'm adding text to a text box in a userform and need to use 14 vbCrLf to add lines. Is there a way to add multiple lines (other than with a loop) using the vbCrLf? I tried
& vbCrLf * 14 but that doesn't work.

Thanks
Gary

Paul_Hossler
01-02-2018, 09:26 AM
Try



Application.WorksheetFunction.Rept(vbCrLf, 14)

zoom38
01-02-2018, 09:51 AM
Thanks Paul, you saved me from excess typing.

gary