Excel UserForms

[Gastank]

Is it possible to format controls in UserForms(e.g. number or date such as mm/dd/yy?

 

[Mudface]

Try, for example,

Private Sub CommandButton1_Click()

CommandButton1.Caption = Format(Now, "dd / mmmm / yy")

End Sub

Note that this can't be done at design time (as far as I know).
This message was edited by Mudface on 2002-02-19 05:37

 

[Gastank]

On 2002-02-19 05:35, Mudface wrote:
Try, for example,

Private Sub CommandButton1_Click()

CommandButton1.Caption = Format(Now, "dd / mmmm / yy")

End Sub

Note that this can't be done at design time (as far as I know).
This message was edited by Mudface on 2002-02-19 05:37

Thanks