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>This is Cool Eric! I am saving this in my VB folder.
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>>