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?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.