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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VB script for Current time
That is because you are putting the formula
=NOW() in the cells Use Private Sub CommandButton1_Click() ActiveCell = Now() End Sub ---------------------- Click 'Yes' if this helps. " wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VB script for Current time
On Jun 1, 11:04*pm, Sheeloo wrote:
That is because you are putting the formula =NOW() in the cells Use Private Sub CommandButton1_Click() ActiveCell = Now() End Sub ---------------------- Click 'Yes' if this helps. " wrote: 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- Hide quoted text - - Show quoted text - Thank you so very much.. It's working... |
Reply |
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 |