Visual Basic & Date

  KW2K 21:22 26 Mar 04

Hi everyone,
Does anyone out their know what the code is for displaying the current date and time in Visual Basic in the folowing format: 26 Oct Thursday 2004 14:23:00. Or does anyone know if their is a Visual Basic forum which could answer this question.


IN all cells that you require the format use
Format Cells - Custom and use the following format.

dd mmm dddd yyyy hh:mm:ss

If you specifically require it in VBA then the following code would set A1 accordingly


Selection.NumberFormat = "dd mmm dddd yyyy hh:mm:ss"

  KW2K 00:09 27 Mar 04

Hi Whisperer,
Thanks for the code, worked a treat !


This thread is now locked and can not be replied to.

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

1995-2015: How technology has changed the world in 20 years

This stop-frame animation tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…