PDA

View Full Version : Display Date & Time on Excel UserForm



adamsm
03-05-2011, 05:15 AM
Hi anyone,

Can anyone tell me how to figure out a way to display today's date & time on excel userform title bar?

Any help on this would be kindly appreciated.

Thanks in advance.

Bob Phillips
03-05-2011, 05:24 AM
Private Sub UserForm_Activate()
Me.Caption = Format(Now(), "dd mmmm yyyy, hh:mm:ss")
End Sub

adamsm
03-05-2011, 05:30 AM
Thanks for the help Xld. But how do I display my userform's name along with the date & time caption.

rrosa1
03-05-2011, 08:43 AM
may be like this

Private Sub UserForm_Activate()
Me.Caption = "your user form " & Format(Now(), "dd mmmm yyyy, hh:mm:ss")
End Sub

adamsm
03-06-2011, 04:02 AM
Thanks for the help rrosa1. I do really appreciate it?