I am generating a word document filled with user inputed values (userform input).
Is there any way to fill the space after typed value with amount of whitespace required to fill the rest of the line?
Or how to get the amount of characters left to the end of line?
Best How To :
Your question is not very clear. This would likely help you anyway.
If you have a
a, which you want to pad with blanks up to 255 characters, you would do
Dim apad As String
apad = a & space(255 - len(a)) ' or
'apad = a & String(255 - len(a), " ") ' or
'apad = a & WorksheetFunction.Rept(" ", 255 - len(a))
You then use
apad for whatever you need.