not able to add date & time to textbox in userform

[narsing rao]

Hi Forum,
i am trying to add date & time to textbox, i have created a userform with combo box and text box in one of the textbox i am trying to display date & time but its not happening.

datebox.Value = Format(Now(), "mm/dd/yyyy hh:mm:ss")

and also tried

Private Sub UserForm_Initialize()
datebox.Value = Format(Now(), "mm/dd/yyyy hh:mm:ss")
end sub

but non of them are working.

 

[NARAYANK991]

Hi ,

I have no problem with your code ; it is working the way it should.

Can you upload your file ?

Narayan

 

[Belleke]

try

(works for me)

PrivateSub UserForm_Initialize()
datebox1.Value = Format(Now, "mm/dd/yyyy hh:mm:ss")
end sub

 

[narsing rao]

Thanks Guys its working now...