A lot of information would be available on a google search. Depending
on how you want to use it, like in a cell or on a user form the code
would change by a bit.
If you can provide details someone can surely provide the code. It
would be in a module and code would be something like:
Public TimeOnOFF As Boolean
Sub Timer()
TimeOnOFF = TRUE
Dim S As Integer
While TimeOnOFF = TRUE
If Second(Now) > S Or Second(Now) = 0 Then
' Run code
'....
'for example
'Sheets("shee1").Range("A1").Value = Time
S = Second(Now)
End If
DoEvents
Wend
End Sub
Hope that helps
Regards,
Anand
On Nov 17, 10:35 pm, ratu elissa <masihgadis...@gmail.com> wrote:
> hot to create time update per second in vba
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
