Option Explicit > >Private Sub Command1_Click() > MsgBox PadL("John", "X", 10) > MsgBox PadR("John", "X", 10) > MsgBox PadC("John", "X", 10) > MsgBox PadC("John", "X", 11) >End Sub > >Private Function PadC(ByVal pstrString As String, _ > ByVal pstrPadChar As String, _ > ByVal pintLen As Integer) As String >Dim intPad As Integer > > pstrString = Trim$(pstrString) > intPad = CInt((pintLen - Len(pstrString)) / 2) > PadC = Left$(String$(intPad, pstrPadChar) & pstrString & String$(intPad + 1, pstrPadChar), pintLen) >End Function > >Private Function PadL(ByVal pstrString As String, _ > ByVal pstrPadChar As String, _ > ByVal pintLen As Integer) As String > pstrString = Trim$(pstrString) > PadL = String$(pintLen - Len(pstrString), pstrPadChar) & pstrString >End Function > >Private Function PadR(ByVal pstrString As String, _ > ByVal pstrPadChar As String, _ > ByVal pintLen As Integer) As String > pstrString = Trim$(pstrString) > PadR = pstrString & String$(pintLen - Len(pstrString), pstrPadChar) >End Function>
Private Sub Command1_Click() >>> MsgBox PadL("John", "X", 6) >>>End Sub >>> >>>Private Function PadL(ByVal pstrString As String, _ >>> ByVal pstrPadChar As String, _ >>> ByVal pintLen As Integer) As String >>> PadL = String$(pintLen - Len(pstrString), pstrPadChar) & pstrString >>>End Function>>>