View Single Post
 
Old 03-18-2015, 12:14 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

maybe

Code:
Dim strValue As String
    strValue = "abc" 'the value from the userform
    If Len(strValue) > 35 Then
        strValue = Left(strValue, 35)
    Else
        Do Until Len(strValue) = 35
            strValue = strValue & Chr(32)
            'OR
            'strValue = Chr(32) & strValue
        Loop
    End If
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote