=NOW() In VBA EXCEL

Is there a way to view the date and time in "real time" in Excel? If so, how????