Make Now Function Display Milliseconds In VBA Macro

I am using a VBA macro (Using mouse clicks as inputs for neuroscience experiment?).

What the macro does is it inputs a timestamp every time a keyboard combination is used (alt+right arrow in this case).

The part of the macro which inputs the timestamp is like this:

Sub AltRight_Sub()
On Error Resume Next
Cancel = True
Cells(Rows.Count, 2).End(xlUp).Offset(1) = Format(Now, "HH:MM:SS")
End Sub

I would like the timestamp to be displayed as HH:MM:SS.00, i.e. show the milliseconds. I tried playing around with the timestamp format (changing it to = Format(Now, "HH:MM:SS.00" or = Format(Now, "HH:MM:SS.0;@")) or = Format(Now, "MM:SS.000") and I tried using = Evaluate("=NOW()") instead of = Format(Now, "HH:MM:SS".