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

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

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...