Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VB script for Current time
Hi there,
I wanted current time to be dispalyed in active cell. So I created a Command button and wrote the following script, though its working fine, when ever i click the button, time in all the cells are getting updated to current time. But I want the current time only in cell where cursor is there. Can any one assit please... Scrip:- sub commondbutton1_Click activecell.formula="=now()" end sub Thanks in advance! Sriki |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Current Time | Excel Discussion (Misc queries) | |||
In Excel: is there a way of inserting the current time (what time it is right NOW) | Excel Discussion (Misc queries) | |||
Having the current time inserted w/o updating the current time | Excel Worksheet Functions | |||
Button/Script to create a new workbook from a current one. | Excel Worksheet Functions | |||
Can I automatically enter the current date or current time into a | New Users to Excel |