| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
programming a macro to display the current time
Can someone tell me how to code a macro to display the current time is a
cell. I am able to get the date and time with using the Now coding, but can't seem to get the only the hours and the minutes. I know this is an easy fix...but help I'm a newbie |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
programming a macro to display the current time
MsgBox Time()
or Sheet1.Range("A1").Value = Time() -- HTH... Jim Thomlinson "sherobot" wrote: Can someone tell me how to code a macro to display the current time is a cell. I am able to get the date and time with using the Now coding, but can't seem to get the only the hours and the minutes. I know this is an easy fix...but help I'm a newbie |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
programming a macro to display the current time
I'm getting Expected value or varible when I put in this code. Do i need to
add something else? sorry for being so green at this. "Jim Thomlinson" wrote: MsgBox Time() or Sheet1.Range("A1").Value = Time() -- HTH... Jim Thomlinson "sherobot" wrote: Can someone tell me how to code a macro to display the current time is a cell. I am able to get the date and time with using the Now coding, but can't seem to get the only the hours and the minutes. I know this is an easy fix...but help I'm a newbie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Current Date & Time in a cell: Everytime I open the workbo | Excel Worksheet Functions | |||
| Display current sheet name being processed in macro | New Users to Excel | |||
| how do I display username, current time & date on the status bar | Excel Programming | |||
| macro for current time | Excel Discussion (Misc queries) | |||
| Help : Macro for capturing current system time | Excel Programming | |||
Linear Mode
