Measuring Time in a user form syntax

Posted to microsoft.public.excel.programming

Martha[_2_] Martha[_2_] is offline

external usenet poster

Posts: 6

Measuring Time in a user form syntax

Hi,
I'm stuck - I have a variable Starttime that I want to
check against Now(). If more than "00::02:30" elapses I
want to do something.

If Now-Starttime "00:02:30" then
do something
end if

What would the proper syntax be?

TIA

Martha

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How do I fill a cell in a user form from a selection on same form?	Terry Tipsy	Excel Discussion (Misc queries)	4	June 11th 07 02:59 PM
User Defined Function Syntax	Ankur	Excel Worksheet Functions	2	January 3rd 07 01:41 PM
Trying to select a specific range based on the time value of user form input	Jitranijam	New Users to Excel	8	November 15th 06 12:52 AM
VBA - Measuring Time -subsecond	PShield	Excel Discussion (Misc queries)	2	August 22nd 06 10:17 AM
User Form That Calculates Time Length and Fills In Other Informati	C A	Excel Worksheet Functions	0	August 1st 05 07:41 PM

All times are GMT +1. The time now is 03:47 PM.

Menu

About Us