Excel UserForms

Gastank · Feb 19th, 2002, 06:07 AM

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

Mudface · Feb 19th, 2002, 06:35 AM

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 · Feb 19th, 2002, 07:38 AM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 06:07 AM	#1
Gastank New Member Join Date: Feb 2002 Posts: 25	Is it possible to format controls in UserForms(e.g. number or date such as mm/dd/yy?

Feb 19th, 2002, 06:35 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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 ]