VBA time and date?

S

Steve

On selecting a commandbutton I need to automatically insert the time and
date into a cell. I know that NOW() would do that but how do i get the time
and date in VBA?

thx

Steve


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080115-0, 15/01/2008
Tested on: 16/01/2008 09:27:14
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hidding buttons 3
Locking Cells 1
Spin button 2
How do you hide ..... 2
Auto insert 2
reset a cell 5
Transparent button 5
autosaving - message box 3

Top