Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 11
Default Windows startup

Dear Sir,

I wrote following codes to display windows Tickcount.
This userform work fine.
When commandbutton1 is pressed then Windows usage time displays.
I want to display it continuously. I mean when Userform loads then it should display running timer.

please help

Code:
Private Declare Function GetTickCount Lib "kernel32" () As Long

Private Sub CommandButton1_Click()
Dim tickcount As Long
    tickcount = GetTickCount()
    Me.TextBox1.Value = tickcount
    Call tick2time
End Sub

Sub tick2time()
    Dim LNTICK As Long, LNHOUR As Integer, LNMIN As Integer
    LNTICK = Me.TextBox1.Value
    TNHOURS = Int(LNTICK / 3600000)
        If (TNHOURS  23) Then
            TNDAYS = Int(TNHOURS / 24)
            TNHOURS = TNHOURS Mod 24
        Else
            TNDAYS = 0
        End If

    LNTICK = LNTICK Mod 3600000
    TNMINUTES = Int(LNTICK / 60000)
    TNSECOND1 = (LNTICK Mod 60000) / 1000
    TNSECONDS = Int(TNSECOND1)
    Me.TextBox2.Value = Format(TNHOURS, "00") + ":" + Format(TNMINUTES, "00") + ":" + Format(TNSECONDS, "00")
    MsgBox ("Windows has started since  " + Me.TextBox2.Value)
End Sub
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows 2000 vs Windows XP raypayette Excel Discussion (Misc queries) 4 July 23rd 06 12:53 PM
Page breaks are different in Windows 2000 and Windows XP Bill Allen Excel Discussion (Misc queries) 1 November 23rd 05 04:42 PM
disable eurovalue windows at excel startup grooviechez Excel Discussion (Misc queries) 4 February 8th 05 01:47 PM
Windows Installer (Visio) on Excel Startup Olly Setting up and Configuration of Excel 0 December 9th 04 04:35 AM
Windows ME and Windows XP Function of key F2 is different jimnav Excel Worksheet Functions 2 November 21st 04 07:05 PM


All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"