Time Keep in VBA - Xtreme Visual Basic Talk

03-09-2004, 05:55 PM

High-Tag

Newcomer

Join Date: Dec 2003

Posts: 12

Time Keep in VBA

How do I calculate the amount of time a user spents on a sheet, and when he closes the sheet, the timer will store the total amount of time spent in another excel sheet? Thanx.

03-10-2004, 12:35 AM

Timbo

Green-Eyed

Super Moderator
* Guru *

Join Date: May 2001

Location: Bangkok, Thailand

Posts: 10,261

Have a look at the 'SheetDeactivate' and 'SheetActivate' events of the 'Workbook' object in your Excel VB help.

__________________
"He's not the Messiah. He's a very naughty boy!" - Brian's mum

Can't find the answer? >> Try something new!
Become a Professional

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
time doesnt update	aaamanagerwebby	Game Programming	5	01-15-2004 07:03 PM
time format not right	poochi80	Database and Reporting	1	01-15-2004 08:01 AM
evaluating time verses curent by 12:00 ?	ICE_BLUE	General	20	07-22-2003 11:16 AM
Getting time from local Win2k server on win98 machine	Tricker	Communications	5	10-21-2002 03:56 AM
Splash Screen Problem	Project1	General	3	10-13-2002 07:20 AM