Comparing Time

[ramedju]

Hi guys!
Anyone know how to compare the input time and current time in excel VBA ?

This is my code Snippet

time = "11:59:59 AM"
If Format(TimeValue(Now)) <= time Then
    test = "Good morning!"
Else
    test = "Good Afternoon!"
End If

This always returns 'Good Afternoon' and it is my problem. Is there's something lacking or anything?

Any help is highly appreciated!

Thank you so much!

 

[Akuini]

Try this

If TimeValue(Now) <= TimeValue("11:59:59 AM") Then
    test1 = "Good morning!"
Else
    test1 = "Good Afternoon!"
End If

 

[ramedju]

Hi Akuini, It seems that it is also that the code you've given is just as the same as I have asked. But thanks for the effort

 

[ramedju]

Hi everyone!
This is my code to solve my problem

   If TimeValue(Now) <= time Then
        test = "Good morning!"
    Else
        test = "Good Afternoon!"
    End If

Thanks!