Userform Date & Time picker

[asyamonique]

Hello is there any way to show time value as in current time when the userform pop up?

 

[silentwolf]

Hi,
Yes it is..
In your userform you can have a textbox and when you start your form it shows the current date with time

me.txtTime.value=now()

HTH

 

[My Aswer Is This]

In your Userform you need a script like this:

Private Sub UserForm_Initialize()
'Modified  10/7/2018  7:23:54 AM  EDT
TextBox2.Value = Time
End Sub

For Time:
Or Now() if you want Date and Time

 

[asyamonique]

Thonks for two of you...

 

[My Aswer Is This]

Glad we were able to help you.

There are three of these type functions:

Time: Gives current Time
Now(): Gives Date and Time
Date: Gives Todays Date