Formatting textboxes on UserForms

[34sweetness]

How can I format a textbox on a UserForm to only allow Date inputs? What about other types of formatting? Ex.: Numbers only.

Also, one of the columns in my worksheet is the some of several other columns. How can I get this ‘sum’ to show up on a UserForm?

 

[Andrew Poulsom]

For point 1 i use the CommandButton (OK) Click event procedure:

Private Sub CommandButton1_Click()
   If Not IsDate(TextBox1.Value) Then
      TextBox1.SetFocus
      Exit Sub
   Else
'     Do whatever
   End If
End Sub

Look in Help for other Is functions (in VB not VBA).