Calendar output

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Patrick C. Simonds - 14 Jul 2007 22:48 GMT

I use the code below to place a date on my form. Is there any way to change
the format of the result to a 2 digit month, 2 digit day and 2 digit year.
currently what I get is 4/18/2007.

Private Sub CommandButton1_Click()
UserForm8.TextBox16.Value = Calendar1.Value
Unload UserForm21
End Sub

---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 000756-1, 07/13/2007
Tested on: 7/14/2007 2:48:21 PM
avast! - copyright (c) 1988-2007 ALWIL Software.
http://www.avast.com

Reply to this Message

Doug Robbins - Word MVP - 14 Jul 2007 23:11 GMT

Use the Format function

UserForm8.TextBox16.Value = Format(Calendar1.Value, "MM/dd/yyyy")

See my comment in your later post about giving meaningful names to your
controls.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I use the code below to place a date on my form. Is there any way to change
>the format of the result to a 2 digit month, 2 digit day and 2 digit year.
[quoted text clipped - 11 lines]
> avast! - copyright (c) 1988-2007 ALWIL Software.
> http://www.avast.com

Reply to this Message