ExcelBanter - textbox string to header causes double spacing

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - textbox string to header causes double spacing (https://www.excelbanter.com/excel-programming/450437-textbox-string-header-causes-double-spacing.html)

[email protected]

textbox string to header causes double spacing

I have a userform that is used to adjust certain print parameters. One of the parameters is the header which is picked up from Textbox1. Textbox1 is preloaded on userform initialization with the following string:

str = Sheet12.Range("ship").Value & Chr(10) & "Total Cost" & Chr(10) & Sheet12.Range("clin").Value

TextBox1.Value = str

All times are GMT +1. The time now is 02:48 AM.