Outlook and userform

[Vibov]

Hi

if i have a userform that add a appointment to the calender and in the form there are some field with fixed size of 35 char. that i have set.
I would like to have this variable to allways has 35 char. even if the user only enter 4 char. and fill the rest of the variable with spaces, how do i do that?

[gmayor]

maybe

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

[Vibov]

Thanks, i'll will try this :-)
Do you know how to write an appointment to a shared calender?