VBA Time format displays "FALSE" in my wooksheet instead of time

[furant]

Hi..

Im just new here and also in VBA. (just like 48 hours ago when i started)

I made a mistake on deleting a bunch of lines earlier but i managed to retype them because i got a a print screen saved. but things doesn't work the same.

i got this code where I want to display the name, time and date of the user when ever he logs in.

this is under a sub way too long to include all, but i think the problem is in these lines only.

'*****************
'Find Rows
'*****************
namerow = Sheet2.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
daterow = Sheet2.Cells(Rows.Count, 2).End(xlUp).Offset(1, 0).Row
timerow = Sheet2.Cells(Rows.Count, 3).End(xlUp).Offset(1, 0).Row

'*****************
'Enter Name, Time and Date
'*****************
Sheet2.Cells(namerow, 1) = Me.cmblist
Sheet2.Cells(daterow, 2) = Format(Now() = "dd-mmm")
Sheet2.Cells(timerow, 3) = Format(Now() = "hh:mm AMPM")

but everytime i run it, excel displays the username in A2, FALSE (for the date) in B2 and FALSE also for the time in C2.

i tried looking for answers and retyped them again and again..
cant find a way to let it show what i want T_T

thanks for the help..

 

[sericom]

Sheet2.Cells(daterow, 2) = Format(Now(), "dd-mmm")
Sheet2.Cells(timerow, 3) = Format(Now(), "hh:mm AMPM")

 

[furant]

Sheet2.Cells(daterow, 2) = Format(Now(), "dd-mmm")
Sheet2.Cells(timerow, 3) = Format(Now(), "hh:mm AMPM")

Thank you very much sir sericom!

it is now working.. :D