I use the "now" function in a textbox to get the timestamp of the systems time but its very basic time and date.

for example [VBA]TextBox1 = Now[/VBA]

I get the following result "04/12/2008 13:11:42"

Is there a way to change the format to say "04/DEC/2008 1.11PM" or "04/DEC/2008 13:11" without the seconds showing?